• Home

  • Products

    • Speedway
    • VITALS
    • Education
  • Services

  • Performance Tips

    • Historical SQL Wait Events
    • Historcal SQL Execution Plan Usage
    • Real Time SQL Performance
    • Database Wide SQL Performance
    • System Topology
    • Real Time Wait Events
    • Historical Wait Events
    • Instance Latching
    • Buffer Cache Content
    • SGA Hit Ratios
    • Performance Advisors
  • Health Scripts

    • Datafile Details
    • Locking Information
    • Segment Growth
    • Data Growth
    • I/O Operations
    • UNDO Usage
  • Articles

    • Tips for Daily Database Health Check
    • Profiling Your Database Workload
    • STATSPACK vs AWR
    • CPU Utilisation
    • ORACLE RAC Health
    • Object KPI's
    • Effective Performance Tuning
    • Performance Advice
    • Waits in Real Time
    • SGA Tuning
    • Database Health Check
    • Execution Plan Flip Flops
    • Health Check Report
  • Contact & Support

    • Contact RIYOSU
    • Troubleshooting & Support
    • Case Study 1
    • Case Study 2
    • Case Study 3
    • Case Study 4
  • Shop

  • More

    Use tab to navigate through the menu items.

    RIYOSU

    0
    Historcal SQL Execution Plan Usage

    SELECT sql_text from dba_hist_sqltext where
    sql_id = '<SQLID Here>';

    SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_AWR('<SQLID Here>','<Plan Hash Value Here>',null,'ALL +OUTLINE'));

    Download Speedway to format and display the results of the above scripts.

    How can Speedway help your database performance?
    Complete Database Performance Management
    LinkedIn

    in