Explain plan for SQLs

How to take Explain plan for SQLs

explain plan into sys.plan_table$ for
..SQL..

select plan_table_output from table(dbms_xplan.display('sys.plan_table$',null,'ALL'));



explain plan for 
..SQL..

select plan_table_output from table(dbms_xplan.display('plan_table',null,'all'));


SELECT * FROM table(DBMS_XPLAN.DISPLAY_CURSOR('gwp663cqh5qbf',0));



EXPLAIN PLAN SET STATEMENT_ID='TSH'


SELECT * FROM table (DBMS_XPLAN.DISPLAY('PLAN_TABLE', 'TSH'));


SELECT * FROM   TABLE(DBMS_XPLAN.DISPLAY('PLAN_TABLE','TSH','BASIC')) where 1=1


SELECT /*+ GATHER_PLAN_STATISTICS */

No comments:

Post a Comment