Automatic extended statistics to improve performance Posted on April 6, 2017, updated on April 6, 2017 by Yannick Jaquier Table of contents Preamble Automatic extended statistics preparation Automatic extended statistics testing References Continue reading
OGG-03517 when moving to Unicode from any other character set Posted on March 10, 2017, updated on April 24, 2017 by Yannick Jaquier Table of contents Preamble OGG-03517 with character set conversion Oracle Database Migration Assistant for Unicode References Continue reading
Audit creation and deletion of users for SOX evidences Posted on February 17, 2017, updated on March 1, 2017 by Yannick Jaquier Table 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 February 14, 2017 by Yannick Jaquier Table 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 January 16, 2017 by Yannick Jaquier Table of contents Preamble GoldenGate 12c installation GoldenGate 12c configuration GoldenGate 12c initial loading GoldenGate 12c apply change data References Continue reading
Oracle OpenStack for Oracle Linux Release 2 installation in Virtualbox (part 2) Posted on December 16, 2016, updated on December 16, 2016 by Yannick Jaquier Table of contents Preamble Oracle OpenStack preparation steps Launch instances References Continue reading