Automatic In-Memory Management (AIM) hands-on Posted on October 30, 2026 , Modified on October 1, 2026 , by Yannick JaquierTable of contents Preamble Automatic In-Memory Management (AIM) activation Automatic In-Memory Management (AIM) test case Automatic In-Memory Management (AIM) testing Automatic In-Memory Management (AIM) with Automatic Data Optimization (ADO) Issues encountered Automatic In-Memory task running forever References Read more Oracle Automatic In-Memory Management (AIM), In-Memory Leave a comment
Real-time SQL Plan Management hands-on Posted on October 15, 2026 , Modified on October 1, 2026 , by Yannick JaquierTable of contents Preamble Real-time SQL Plan Management setup Real-time SQL Plan Management test case Table creation Perfect world situation Someone has (wrongly) gathered statistics on a table References Read more Oracle Automatic SQL Plan Management (ASPM), Real-time SQL Plan Management, SQL Plan Management (SPM) Leave a comment
Flink CDC for database replication to big data Posted on September 30, 2026 , Modified on October 23, 2026 , by Yannick JaquierTable of contents Preamble Iceberg installation in Spark Flink installation Flink CDC installation PostgreSQL source database configuration Iceberg sink configuration MariaDB source database configuration Oracle source database configuration Issues encountered Connection refused /tmp in noexec REST/Web UI upload handler still in /tmp References Read more Hadoop, MariaDB, MySQL, Oracle, PostgreSQL Development Leave a comment
Performance reports (ADDM, ASH and AWR) without linux access Posted on September 15, 2026 , Modified on September 3, 2026 , by Yannick JaquierTable of contents Preamble Automatic Database Diagnostic Monitor (ADDM) Active Session History (ASH) Automatic Workload Repository (AWR) Read more Oracle Active Session History (ASH), Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR), Tuning Leave a comment
Virtual DBA application – part 3 Posted on August 30, 2026 , Modified on August 31, 2026 , by Yannick JaquierTable of contents Preamble Embeddings FAISS Reciprocal Rank Fusion (RRF) Next steps Read more Oracle, Python Artificial intelligence (AI) Leave a comment
Virtual DBA application – part 2 Posted on August 15, 2026 , Modified on August 24, 2026 , by Yannick JaquierTable of contents Preamble Chunking of markdown files Keyword search (BM25) First version of the application Read more Oracle, Python Artificial intelligence (AI) 1 comment