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 November 11, 2020 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 September 22, 2023 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 April 19, 2022 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
RMAN and TDPO performance testing Posted on July 18, 2011, updated on May 27, 2019 by Yannick JaquierTable of contents Preamble Backup with TDPO results Restore with TDPO results Issues encountered Not able to delete backup files Control file backup missing Online backup with TDPO References Continue reading