Oracle Database Metrics Exporter hands-on Posted on May 30, 2026 , Modified on June 10, 2026 , by Yannick JaquierTable of contents Preamble Prometheus configuration Oracle Database Metrics Exporter installation Grafana Oracle Database Metrics Exporter Metrics and visualization customization Read more Oracle Active Session History (ASH), Administration, SQL 2 comments
Is JSON datatype performance really faster than BLOB datatype ? Posted on January 20, 2025 , Modified on June 12, 2026 , by Yannick JaquierTable of contents Preamble Loading JSON into Oracle with Python JSON queries and performance comparison JSON basic queries JSON performance comparison To go further with JSON performance References Read more Oracle Development, SQL Leave a comment
Performance schema hands-on – part 2 Posted on October 30, 2024 , Modified on December 6, 2024 , by Yannick JaquierTable of contents Preamble Performance Schema with global and digest instrumentation Performance Schema with global, thread and current event instrumentation Performance Schema with global, thread and event history instrumentation Performance Schema impact References Read more MariaDB, MySQL SQL, Tuning 1 comment
Performance schema hands-on – part 1 Posted on October 10, 2024 , Modified on December 6, 2024 , by Yannick JaquierTable of contents Preamble Performance schema activation and configuration Performance Schema with global instrumentation Only Performance Schema with global and thread instrumentation References Read more MariaDB, MySQL SQL, Tuning 2 comments
How to load JSON into MariaDB Posted on May 20, 2024 , Modified on June 12, 2026 , by Yannick JaquierTable of contents Preamble Preparation Load JSON into MariaDB only with SQL Load JSON into MariaDB with Python References Read more MariaDB JSON, SQL 1 comment
In-Memory OLTP for rapid data ingestion Posted on April 20, 2024 , Modified on April 22, 2024 , by Yannick JaquierTable of contents Preamble In-Memory OLTP preparation In-Memory OLTP testing In-Memory OLTP to durable tables INSERT INTO disk_based_table SELECT FROM memory_optimized_table Temporal memory-optimized table Issues encountered References Read more SQL Server SQL, Tuning Leave a comment