| xplan_role.sql |
- |
Creates a role with the privileges needed to run dbms_xplan. |
| xplan.sql |
- |
Script to create an explain plan for a given SQL statement. Just edit the script and add your SQL statement. |
| xplan_display.sql |
- |
Avoids having to run the SQL statement. Generates an explain plan with dbms_xplan.display function after explaining the SQL statement in the script. Just edit the script and add your SQL statement. |
| xplan_sqlid_cursor.sql |
- |
Creates an explain plan for an input sql_id. Uses the dbms_xplan.display_sursor function. |
| xplan_session_cursor.sql |
- |
Creates an explain plan for an input sql_id. Uses the dbms_xplan.display_sursor function. It first displays all of the session cursors available. |
| xplan_sqlid_awr.sql |
- |
Creates an explain plan for an AWR sql_id using the dbms_xplan.display_awr function. |
