MHVTL Virtual Tape Library (VTL) hands-on Posted on November 15, 2026 , Modified on November 2, 2026 , by Yannick JaquierTable of contents Preamble MHVTL Installation Testing Manage disk space before / is full My MHVTL final configuration Oracle Secure Backup (OSB) RMAN testing Script to clean all tapes Issues encountered Pending resource availability Barcode is required on, but missing from, volume Remove non existent device attached to volumes References Read more Linux Backup, RMAN Leave a comment
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