PLAN_TABLE (explain plan for ...) V$SQL_PLAN (Library Cache) DBA_HIST_SQL_PLAN (AWR) STATS$SQL_PLAN (Statspack) Event 10046 trace file & tkprof Event 10053 trace file |
SQL> explain plan for select * from emp; |
SQL> @?/rdbms/admin/utlxplp SQL> @?/rdbms/admin/utlxpls SQL> select * from table(dbms_xplan.display()); |
SQL> conn scott/tiger SQL> set autotrace on SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled SP2-0611: Error enabling STATISTICS report SQL> conn / as sysdba SQL> @?/sqlplus/admin/plustrce.sql SQL> grant plustrace to scott; |
SQL> conn scott/tiger Connected. SQL> set autotrace on SQL> select * from emp where empno=7782; |
SET AUTOTRACE {OFF|ON|TRACEONLY} [EXPLAIN][STATISTICS] |
SQL> set autotrace on |
SQL> set autotrace off |
SQL> set autotrace traceonly |
SQL> set autotrace traceonly explain |
SQL> set autotrace traceonly statistics |
SQL> set autotrace on explain |
set autotrace on explain |
SQL> select * from table(dbms_xplan.display_cursor()); |
SQL> select sql_id,child_number,sql_text from v$sql where sql_text like 'select e.ename%'; SQL> select * from table(dbms_xplan.display_cursor('f58s78jh6w00j',0,'TYPICAL')); |
SQL> select t.* from v$session s,table(dbms_xplan.display_cursor(s.sql_id,s.sql_child_number,'TYPICAL')) t where sid=&SID; |
image001.png (208.07 KB, 下载次数: 119)
欢迎光临 168大数据 (http://www.bi168.cn/) | Powered by Discuz! X3.2 |