《oracle效能工具包》

主要描述oracle效能工具包的使用與內容解釋，完善中。。。。[@more@]

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