Audit creation and deletion of users for SOX evidences Posted on February 17, 2017, updated on February 21, 2022 by Yannick JaquierTable of contents Preamble Oracle Legacy audit Unified audit Audit cleaning SQL Server Audit Audit cleaning MySQL MariaDB audit plugin McAfee audit plugin Percona audit plugin References Oracle SQL Server MySQL Continue reading
PL/SQL performance tuning with bulk SQL/binding and parallelism Posted on February 14, 2017, updated on March 26, 2021 by Yannick JaquierTable of contents Preamble Setup Classical method Bulk SQL method DBMS_PARALLEL_EXECUTE method Raw results References Continue reading
GoldenGate 12c (12.2) installation and configuration Posted on January 16, 2017, updated on April 28, 2020 by Yannick JaquierTable of contents Preamble GoldenGate 12c installation GoldenGate 12c configuration GoldenGate 12c initial loading GoldenGate 12c apply change data References Continue reading
How to submit an external script with Oracle scheduler Posted on October 25, 2016, updated on October 25, 2016 by Yannick JaquierTable of contents Preamble Oracle scheduler external job References Continue reading
Incremental statistics on partitioned tables Posted on June 29, 2016, updated on June 29, 2016 by Yannick JaquierTable of contents Preamble Incremental statistics Results References Continue reading
Aggregated global statistics on partitioned tables or not ? Posted on June 1, 2016, updated on May 2, 2018 by Yannick JaquierTable of contents Preamble Partitioned test table Aggregated global statistics Gathered global statistics Global statistics performance comparison References Continue reading