Transactional Event Queues (TxEventQ) hands-on Posted on April 30, 2025, updated on April 30, 2025 by Yannick JaquierTable of contents Preamble Transactional Event Queues (TxEventQ) creation Enqueue/dequeue testing with PL/SQL Enqueue a message Dequeue a message Enqueue/dequeue testing with Python Enqueue a message Dequeue a message Enqueue/dequeue testing with Java Errors encountered Enqueue and dequeue a message Advanced Queueing (AQ) testing Queue and subscribers creation Enqueue a message Dequeue a message References Continue reading
SQL Server compression methods testing and comparison Posted on April 10, 2025, updated on April 10, 2025 by Yannick JaquierTable of contents Preamble SQL Server compression test case SQL Server compression testing sp_estimate_data_compression_savings Row compression Page compression COMPRESS/DECOMPRESS compression Columnstore compression Columnstore archive compression SQL Server compression wrap up References Continue reading
Convert a database to Unicode (AL32UTF8) Posted on March 20, 2025, updated on March 10, 2025 by Yannick JaquierTable of contents Preamble DMU preparation DMU scan the database DMU Resolve migration issue DMU convert the database to Unicode References Continue reading
Transparent Application Continuity (TAC) hands-on Posted on March 2, 2025, updated on February 20, 2025 by Yannick JaquierTable of contents Preamble Transparent Application Continuity (TAC) setup Transparent Application Continuity (TAC) testing with SQL*Plus TAC compatible service Transparent Application Continuity (TAC) testing with Java Errors encountered Service not automatically started References Continue reading
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