YET ANOTHER ORACLE DBA

Focus on Oracle DBA (Core/Apps/Fusion) stuffs

Posts Tagged ‘cursor is not available in memory’

Steps to get the actual execution plan for a SQL statement between two AWR snapshots?

Posted by Jay on August 9, 2011

The following are the steps to get the actual explain plan statement of a query ran between two snapshots when the cursor is not available in memory.

1) Query  the SQL_ID from V$SQL

2) Run the following script: $ORACLE_HOME/rdbms/admin/awrsqrpt.sql

3) Specify the begin/end snapshots and the sql_id

4) Review the output for the actual explain plan of the sql

 

Posted in Database, Performance | Tagged: , , , , , | Leave a Comment »