本帖最后由 bibabo 于 2011-10-17 16:20 编辑
maclean 发表于 2011-10-16 16:37
见我的回复这个事单sql的awr
Plan Statistics
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
Stat Name Statement Total Per Execution % Snap Total
Elapsed Time (ms) 7,875 3,937.46 0.04
CPU Time (ms) 8,064 4,031.89 0.04
Executions 2
Buffer Gets 322,125 161,062.50 0.00
Disk Reads 0 0.00 0.00
Parse Calls 2 1.00 0.00
Rows 9,770 4,885.00
User I/O Wait Time (ms) 0
Cluster Wait Time (ms) 0
Application Wait Time (ms) 0
Concurrency Wait Time (ms) 0
Invalidations 0
Version Count 2
Sharable Mem(KB) 46
Execution Plan
IdOperationNameRowsBytesCost (%CPU) Time
0UPDATE STATEMENT43973 (100)
1 UPDATETEMP_ABC
2 TABLE ACCESS FULLTEMP_ABC4885147K 8 (0) 00:00:01
3 SORT AGGREGATE131
4 TABLE ACCESS FULL TEMP_ABC51558 (0) 00:00:01
|