1、explan plan用法
SQL> @?/rdbms/admin/utlxplan
表已创建。
SQL> explain plan for
2 select * from qq;
已解释。
SQL> @?/rdbms/admin/utlxpls;
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
Plan hash value: 2404684029
--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 527 | 3 (0)| 00:00:01 |
| 1 | TABLE ACCESS FULL| QQ | 1 | 527 | 3 (0)| 00:00:01 |
--------------------------------------------------------------------------
Note
-----
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
- dynamic sampling used for this statement
已选择12行。
2、set autotrace on
3、TKPROF
alter session set timed_statistics=true;
alter session set events '10046 trace name context forever,level 12';
alter session set sql_trace=true;
tkprof *.trc tk.prf
4、Statspack报告
@?/rdbms/admin/spdrop
@?/rdbms/admin/spcreate
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22630256/viewspace-1033489/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22630256/viewspace-1033489/