AWR baselines and performance comparison Posted on May 8, 2013, updated on November 13, 2024 by Yannick JaquierTable of contents Preamble Good performance Bad performance Performance improved Conclusion References Continue reading
Invisible indexes by example Posted on November 11, 2012, updated on June 25, 2015 by Yannick JaquierTable of contents Preamble Invisible indexes implementation Continue reading
Red Hat / Oracle Linux I/O scheduler tuning for Oracle databases Posted on July 19, 2012, updated on June 18, 2024 by Yannick JaquierTable of contents Preamble ktune (Red Hat 5) tuned (Red Hat 6) References Continue reading
Linux Huge Pages and virtual memory (VM) tuning Posted on July 12, 2012, updated on July 8, 2024 by Yannick JaquierTable of contents Preamble Huge Pages implementation Not swapping PGA References Continue reading
Veritas File System (VxFS) tuning Posted on July 6, 2012, updated on July 8, 2024 by Yannick JaquierTable of contents Preamble VxFS file system physical parameters Block size Intent log size File extents VxFS file system tuning Tunable filesystem parameters File system fragmentation Mount options Database accelerators Veritas Extension for Oracle Disk Manager Veritas Cached Oracle Disk Manager References Continue reading
DBMS_SQLTUNE concrete example Posted on September 30, 2011, updated on May 28, 2019 by Yannick JaquierTable of contents Preamble Tuning task DBMS_SQLTUNE result With Grid Control Continue reading