Can Recycle Bin impact performance ? Posted on August 30, 2013 , Modified on August 7, 2015 , by Yannick JaquierTable of contents Preamble How recycle bin comes in loop References Read more Oracle SQL, Tuning Leave a comment
Database hanging for high version count and SYS_REFCURSOR usage Posted on June 5, 2013 , Modified on October 21, 2026 , by Yannick JaquierTable of contents Initial problem First solution and second problem Second solution References Read more Oracle SQL, Tuning Leave a comment
AWR baselines and performance comparison Posted on May 8, 2013 , Modified on November 13, 2024 , by Yannick JaquierTable of contents Preamble Good performance Bad performance Performance improved Conclusion References Read more Oracle Automatic Workload Repository (AWR), Tuning 1 comment
Invisible indexes by example Posted on November 11, 2012 , Modified on June 25, 2015 , by Yannick JaquierTable of contents Preamble Invisible indexes implementation Read more Oracle Tuning 2 comments
Red Hat / Oracle Linux I/O scheduler tuning for Oracle databases Posted on July 19, 2012 , Modified on October 21, 2026 , by Yannick JaquierTable of contents Preamble ktune (Red Hat 5) tuned (Red Hat 6) References Read more Linux, Oracle Tuning 2 comments
Linux Huge Pages and virtual memory (VM) tuning Posted on July 12, 2012 , Modified on October 21, 2026 , by Yannick JaquierTable of contents Preamble Huge Pages implementation Not swapping PGA References Read more Linux, Oracle Automatic Memory Management (AMM), Automatic Shared Memory Management (ASMM), Huge Pages, Tuning, Virtual Memory 6 comments