Mahamad Sulthan Oracle Applications
Friday, February 18, 2011
How to explain Query
Step 1) Statement id has to be passed it can be any alpha numeric combination
EXPLAIN PLAN
SET STATEMENT_ID = 'abc' FOR
SELECT * FROM emp WHERE deptno=20
Step 2)
SELECT * FROM TABLE(dbms_xplan.display('PLAN_TABLE','abc','ALL'));
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment