The Application DBA  

Oracle DBMS_XPLAN Scripts

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_cursor function.
xplan_session_cursor.sql - Creates an explain plan for an input sql_id. Uses the dbms_xplan.display_cursor 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.

 

Copyright 1998-2013 AppsDBA Consulting. All Rights Reserved.