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'));
Friday, September 10, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment