Friday, September 10, 2010

Display Plan for last executed SQL

Display Plan for last executed SQL
==========================================

1) Execute SQL

2) Run Below to get plan.

select * from table(dbms_xplan.display_cursor);

Display Plan for Any SQL in Cursor Cache
=============================================

SELECT * FROM TABLE(DBMS_XPLAN.display_cursor(sql_id=>'&YOUR_SQL_ID'));

No comments:

Post a Comment