Database hanging for high version count and SYS_REFCURSOR usage Posted on June 5, 2013, updated on March 26, 2021 by Yannick JaquierTable of contents Initial problem First solution and second problem Second solution References Continue reading
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