Visualizing Active Session History (ASH) to produce Grid Control charts Posted on February 17, 2012, updated on October 16, 2023 by Yannick JaquierTable of contents Preamble Without CPU Wait With CPU wait With Oracle pre 11g Conclusion References Continue reading
Database Replay by example Posted on January 25, 2012, updated on May 28, 2019 by Yannick JaquierTable of contents Preamble Capture Replay Database replay result and cleaning References Continue reading
Real-Time SQL Monitoring Posted on January 11, 2012, updated on May 28, 2019 by Yannick JaquierTable of contents Preamble Grid Control Command line Conclusion Continue reading
SQL Plan Management Posted on December 22, 2011, updated on July 3, 2024 by Yannick JaquierTable of contents Preamble Testing Testing with Adaptive Cursor Sharing (ACS) Testing with SQL Profile Link between sql_id and SQL Plan Baselines Conclusion References Continue reading
SQL Performance Analyzer Posted on November 29, 2011, updated on August 7, 2015 by Yannick JaquierTable of contents Preamble SQL Performance Analyzer testing SQL Performance Analyzer result References Continue reading
Compression Advisor Posted on November 11, 2011, updated on August 7, 2015 by Yannick JaquierTable of contents Preamble Compression Advisor with DBMS_COMPRESSION Compression Advisor with DBMS_ADVISOR Continue reading