One Database, Six Workloads: Analyzing F1 Telemetry With Oracle Converged Database
The Complexity We Created Somewhere along the way, we convinced ourselves that specialized...
Read More
Category: OracleDB
Integrating Oracle AI Vector, Ollama, and Mistral
The convergence of relational databases and generative AI is reshaping data architecture. By...
Read More
Spotify music clustering with Oracle AI Vector: From vectors to visual insights
The article uses Oracle AI Vector for a use case to cluster and visualize vectors. In my previous...
Read More
Oracle AI Vector – Semantic Search
With the advent of Large Language Models (LLM), vector databases are becoming increasingly...
Read More
Data Engineering with dbt – first steps using PostgreSQL and Oracle
dbt is a Data Engineering tool supporting version control with CI/CD for transformations and...
Read More
DOAG 2017 & Oracle 18c: DBIM (Oracle Database In-Memory) new features
The annual DOAG 2017 conference took place from 21-NOV-2017 to 24-NOV 2017 in Nuremberg. As usual,...
Read More
Oracle Release Model, Release Updates (RU), Monthly Recommended Patches (MRPs) and discontinued Release Update Revisions (RUR)
Update Oct/2022 Monthly recommended patches will replace Release Update Revisions (RURs) from...
Read MoreDBCA causes ORA-27104
DBCA fails with error message ORA-27104 on Linux [ 2017-09-03 20:49:06.137 CEST ] Creating and starting Oracle instance DBCA_PROGRESS : 1% DBCA_PROGRESS : 2% [ 2017-09-03 20:49:07.366 CEST ] ORA-27104: system-defined limits for...
Read More
SQL Tuning – filtered rows percentage method
Kevin Meade is the author and publisher of his own book “Oracle SQL Performance Tuning and...
Read MoreSQL – Only the Strong Survive
There are tons of tech predictions at the end of every year. Eric Knorr lists “The incredible SQL comeback” in his 9 enterprise tech trends for 2017 and beyond. An old, mature programming language as the...
Read MoreIs my Oracle database healthy?
It’s a common question if a database is in a healthy state. DBA_REGISTRY shows the status of components loaded into the database. Mike Dietrich mentions in his blog two additional checks that should be performed regularly...
Read More