Oracle Data Guard per Pluggable Database hands-on Posted on February 10, 2025, updated on February 10, 2025 by Yannick JaquierTable of contents Preamble Databases Data Guard preparation Container databases preparation Create a new pluggable database for replication Data Guard Broker configuration Data Guard Broker configuration creation Copy of source pluggable database datafiles Pluggable Data Guard testing Preparation Switchover Failover Pluggable Data Guard cleaning Errors encountered ORA-00922: missing or invalid option wth edit configuration prepare dgpdb command _DGMGRL legacy service name RMAN duplicate command error DGM-17437 References Continue reading
Is JSON datatype performance really faster than BLOB datatype ? Posted on January 20, 2025, updated on January 20, 2025 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 Continue reading
Automatic SQL Plan Management (ASPM) hands-on Posted on December 30, 2024, updated on January 6, 2025 by Yannick JaquierTable of contents Preamble Automatic SQL Plan Management (ASPM) setup Automatic SQL Plan Management (ASPM) test case We live in a peaceful world (so far) Who has messed up ? Automatic SPM to the rescue References Continue reading
SYS schema hands-on Posted on December 10, 2024, updated on December 10, 2024 by Yannick JaquierTable of contents Preamble SYS schema configuration Instances global waits SYS schema schema view SYS schema side procedures sys.diagnostics() sys.statement_performance_analyzer() sys.format_time() and sys.format_bytes() References Continue reading
Information schema hands-on Posted on November 20, 2024, updated on November 20, 2024 by Yannick JaquierTable of contents Preamble Information Schema configuration Information Schema global status queries Aborted clients All clients traffic Comparison of on-disk and memory temporary tables Com_xxx and Handler_xxx variables InnoDB free and dirty space and data read and written InnoDB log buffer write rate Query cache statistics Tables joins performance Information Schema InnoDB queries InnoDB buffer pool statistics InnoDB locks InnoDB metrics Information Schema remaining tables Processlist Routines Users and Schemas privileges System variables References Continue reading
Performance schema hands-on – part 2 Posted on October 30, 2024, updated 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 Continue reading