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 */
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