其中的CPU TIME是Oracle 9i以后引入的，这里其实需要指出的是，
调优的第一手资料其实还是从statspack中的这个部分来分析，
那么结合我们的top 5的等待事件，我们可以来衡量不同等级的top sql:
1.消耗最多CPU的(逻辑IO比较多的)
2.导致过多物理I/O的(物理IO比较多的)
3.执行次数较频繁的(Execution次数比较多的)
4.执行时间较长的(Elapse time比较长的)
其实在Oracle世界里有一套关于resposne time的分析方法：
Response time=Service time + Wait time
其实Service time就是CPU为执行该语句花费的时间。
Service Time=CPU Parse + CPU Recursive + CPU Other 三部分组成
CPU Parse是CPU用于分析语句的时间，
CPU Recursive是CPU用于语句的递归SQL的时间，
CPU Other则就是CPU用于执行语句的真正时间了。
在Statpacks中Instance Activity Stats中就有部分的时间统计信息：
Service time=CPU used by this session
CPU Parse=parse time cpu
CPU Resursive=recursive cpu usage
所以CPU ther=CPU used by this session -parse time cpu -recursive cpu usage
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ % Total
Event Waits Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
CPU time 13,202 94.60
SQL*Net more data to client 683,062 174 1.24
control file parallel write 10,608 136 .97
db file sequential read 24,239 83 .59
ARCH wait on SENDREQ 1,326 66 .47
分析：
从statspack报告获取一些值：
CPU used by this session 1,320,152 40.8 13.8
parse time cpu 3,095 0.1 0.0
parse time elapsed 3,446 0.1 0.0
recursive cpu usage 184,512 5.7 1.9
CPU Time的total call time%是94.6%
CPU Time=94%
CPU ther=1320152 -3095 -184512 =1132545
CPU ther=1132545/1320152*94%=80%
CPU Parse=3095/1320152*94%=忽略不计
CPU Recursive=184512/1320152*94%=13%
从上面的数据可知：
cpu ther时间最多，占了80%，说明在执行SQL语句的时候开销了大量cpu时间.
附部分statspack报告：
STATSPACK report for
DB Name DB Id Instance Inst Num Release Cluster Host
------------ ----------- ------------ -------- ----------- ------- ------------
SHESTATE 3563853082 rac2 2 9.2.0.5.0 YES DB-p670-02-p
1
Snap Id Snap Time Sessions Curs/Sess Comment
------- ------------------ -------- --------- -------------------
Begin Snap: 7174 09-Jan-11 08:00:01 3,025 4.8
End Snap: 7202 09-Jan-11 17:00:00 3,027 4.8
Elapsed: 539.98 (mins)
Cache Sizes (end)
~~~~~~~~~~~~~~~~~
Buffer Cache: 10,000M Std Block Size:
8K
Shared Pool Size: 1,808M Log Buffer:
1,536K
Load Profile
~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Redo size: 4,489.49 1,519.03
Logical reads: 10,738.54 3,633.42
Block changes: 23.31 7.89
Physical reads: 9.93 3.36
Physical writes: 5.39 1.82
User calls: 97.38 32.95
Parses: 15.89 5.38
Hard parses: 0.94 0.32
Sorts: 2.72 0.92
Logons: 0.07 0.02
Executes: 41.91 14.18
Transactions: 2.96
% Blocks changed per Read: 0.22 Recursive Call %: 27.10
Rollback per transaction %: 1.62 Rows per Sort: 388.58
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 99.97 In-memory Sort %: 100.00
Library Hit %: 98.63 Soft Parse %: 94.11
Execute to Parse %: 62.09 Latch Hit %: 99.96
Parse CPU to Parse Elapsd %: 89.81 % Non-Parse CPU: 99.77
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 89.83 89.55
% SQL with executions>1: 45.36 47.79
% Memory for SQL w/exec>1: 80.87 82.52
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ % Total
Event Waits Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
CPU time 13,202 94.60
SQL*Net more data to client 683,062 174 1.24
control file parallel write 10,608 136 .97
db file sequential read 24,239 83 .59
ARCH wait on SENDREQ 1,326 66 .47
-------------------------------------------------------------
Cluster Statistics for DB: SHESTATE Instance: rac2 Snaps: 7174 -7202
Global Cache Service - Workload Characteristics
-----------------------------------------------
Ave global cache get time (ms): 0.5
Ave global cache convert time (ms): 7.0
Ave build time for CR block (ms): 0.0
Ave flush time for CR block (ms): 0.3
Ave send time for CR block (ms): 0.0
Ave time to process CR block request (ms): 0.4
Ave receive time for CR block (ms): 0.5
Ave pin time for current block (ms): 0.1
Ave flush time for current block (ms): 0.0
Ave send time for current block (ms): 0.1
Ave time to process current block request (ms): 0.2
Ave receive time for current block (ms): 2.3
Global cache hit ratio: 0.0
Ratio of current block defers: 0.0
% of messages sent for buffer gets: 0.0
% of remote buffer gets: 0.0
Ratio of I/O for coherence: 0.3
Ratio of local vs remote work: 8.3
Ratio of fusion vs physical writes: 0.0
Global Enqueue Service Statistics
---------------------------------
Ave global lock get time (ms): 0.0
Ave global lock convert time (ms): 0.0
Ratio of global lock gets vs global lock releases: 1.1
GCS and GES Messaging statistics
--------------------------------
Ave message sent queue time (ms): 0.1
Ave message sent queue time on ksxp (ms): 4.4
Ave message received queue time (ms): 0.1
Ave GCS message process time (ms): 0.0
Ave GES message process time (ms): 0.0
% of direct sent messages: 42.2
% of indirect sent messages: 37.9
% of flow controlled messages: 19.9
-------------------------------------------------------------
GES Statistics for DB: SHESTATE Instance: rac2 Snaps: 7174 -7202
Statistic Total per Second per Trans
--------------------------------- ---------------- ------------ ------------
dynamically allocated gcs resourc 0 0.0 0.0
dynamically allocated gcs shadows 0 0.0 0.0
flow control messages received 34 0.0 0.0
flow control messages sent 208 0.0 0.0
gcs ast xid 7 0.0 0.0
gcs blocked converts 1,573 0.0 0.0
gcs blocked cr converts 250 0.0 0.0
gcs compatible basts 0 0.0 0.0
gcs compatible cr basts (global) 4 0.0 0.0
gcs compatible cr basts (local) 131,498 4.1 1.4
gcs cr basts to PIs 0 0.0 0.0
gcs cr serve without current lock 0 0.0 0.0
gcs error msgs 0 0.0 0.0
gcs flush pi msgs 326 0.0 0.0
gcs forward cr to pinged instance 0 0.0 0.0
gcs immediate (compatible) conver 4,406 0.1 0.0
gcs immediate (null) converts 9,752 0.3 0.1
gcs immediate cr (compatible) con 12,009 0.4 0.1
gcs immediate cr (null) converts 811,241 25.0 8.5
gcs msgs process time(ms) 47,361 1.5 0.5
gcs msgs received 1,834,880 56.6 19.2
gcs out-of-order msgs 0 0.0 0.0
gcs pings refused 1 0.0 0.0
gcs queued converts 0 0.0 0.0
gcs recovery claim msgs 0 0.0 0.0
gcs refuse xid 2 0.0 0.0
gcs retry convert request 0 0.0 0.0
gcs side channel msgs actual 5,219 0.2 0.1
gcs side channel msgs logical 59,363 1.8 0.6
gcs write notification msgs 38 0.0 0.0
gcs write request msgs 304 0.0 0.0
gcs writes refused 4 0.0 0.0
ges msgs process time(ms) 2,100 0.1 0.0
ges msgs received 70,295 2.2 0.7
global posts dropped 0 0.0 0.0
global posts queue time 0 0.0 0.0
global posts queued 0 0.0 0.0
global posts requested 0 0.0 0.0
global posts sent 0 0.0 0.0
implicit batch messages received 172,153 5.3 1.8
implicit batch messages sent 11,130 0.3 0.1
lmd msg send time(ms) 753 0.0 0.0
lms(s) msg send time(ms) 15 0.0 0.0
messages flow controlled 45,696 1.4 0.5
messages received actual 1,012,521 31.3 10.6
messages received logical 1,902,917 58.7 19.9
messages sent directly 96,730 3.0 1.0
messages sent indirectly 86,757 2.7 0.9
msgs causing lmd to send msgs 26,498 0.8 0.3
msgs causing lms(s) to send msgs 6,923 0.2 0.1
msgs received queue time (ms) 108,014 3.3 1.1
msgs received queued 1,902,507 58.7 19.9
msgs sent queue time (ms) 8,673 0.3 0.1
msgs sent queue time on ksxp (ms) 757,267 23.4 7.9
msgs sent queued 86,520 2.7 0.9
msgs sent queued on ksxp 170,720 5.3 1.8
GES Statistics for DB: SHESTATE Instance: rac2 Snaps: 7174 -7202
Statistic Total per Second per Trans
--------------------------------- ---------------- ------------ ------------
process batch messages received 169,922 5.2 1.8
process batch messages sent 12,525 0.4 0.1
-------------------------------------------------------------
Wait Events for DB: SHESTATE Instance: rac2 Snaps: 7174 -7202
-> s - second
-> cs - centisecond - 100th of a second
-> ms - millisecond - 1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc (idle events last)
Avg
Total Wait wait Waits
Event Waits Timeouts Time (s) (ms) /txn
---------------------------- ------------ ---------- ---------- ------ --------
SQL*Net more data to client 683,062 0 174 0 7.1
control file parallel write 10,608 0 136 13 0.1
db file sequential read 24,239 0 83 3 0.3
ARCH wait on SENDREQ 1,326 0 66 50 0.0
log file sync 27,551 1 55 2 0.3
direct path read (lob) 72,497 0 50 1 0.8
db file parallel write 2,486 0 36 15 0.0
control file sequential read 80,587 0 33 0 0.8
SQL*Net break/reset to clien 59,846 0 23 0 0.6
db file scattered read 6,258 0 22 4 0.1
direct path read 6,153 0 11 2 0.1
process startup 88 0 10 117 0.0
global cache null to x 323 12 8 26 0.0
global cache cr request 56,134 278 6 0 0.6
wait for master scn 10,797 0 6 1 0.1
direct path write 4,423 0 6 1 0.0
global cache open x 3,799 15 6 1 0.0
enqueue 29,450 0 6 0 0.3
CGS wait for IPC msg 311,691 311,690 4 0 3.3
async disk IO 518 0 3 5 0.0
KJC: Wait for msg sends to c 9,119 0 2 0 0.1
global cache null to s 113 1 1 12 0.0
SQL*Net message from dblink 37 0 1 34 0.0
global cache busy 20 0 1 49 0.0
log file sequential read 144 0 1 6 0.0
library cache lock 3,221 0 1 0 0.0
buffer busy waits 1,411 0 1 0 0.0
DFS lock handle 2,669 0 1 0 0.0
global cache open s 245 40 1 2 0.0
LGWR wait for redo copy 5,870 11 1 0 0.1
global cache s to x 897 18 1 1 0.0
ksxr poll remote instances 24,749 23,984 0 0 0.3
latch free 111 86 0 2 0.0
log file parallel write 76,565 72,148 0 0 0.8
row cache lock 659 0 0 0 0.0
db file parallel read 16 0 0 5 0.0
log file single write 8 0 0 5 0.0
db file single write 2 0 0 9 0.0
library cache pin 25 0 0 0 0.0
SQL*Net more data from dblin 2 0 0 0 0.0
buffer busy global CR 1 0 0 0 0.0
SQL*Net message to dblink 37 0 0 0 0.0
SQL*Net more data to dblink 1 0 0 0 0.0
buffer deadlock 11 11 0 0 0.0
undo segment extension 1 0 0 0 0.0
SQL*Net message from client 2,703,653 0 1,612,443 596 28.2
gcs remote message 1,905,916 1,870,724 94,830 50 19.9
ges remote message 853,097 852,897 31,610 37 8.9
jobq slave wait 1,829 1,823 5,482 2997 0.0
Wait Events for DB: SHESTATE Instance: rac2 Snaps: 7174 -7202
-> s - second
-> cs - centisecond - 100th of a second
-> ms - millisecond - 1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc (idle events last)
Avg
Total Wait wait Waits
Event Waits Timeouts Time (s) (ms) /txn
---------------------------- ------------ ---------- ---------- ------ --------
SQL*Net message to client 2,703,657 0 2 0 28.2
SQL*Net more data from clien 3,123 0 1 0 0.0
-------------------------------------------------------------
Background Wait Events for DB: SHESTATE Instance: rac2 Snaps: 7174 -7202
-> ordered by wait time desc, waits desc (idle events last)
Avg
Total Wait wait Waits
-------------------------
96.3 36,247 1,399
%PGA %Auto %Man
PGA Aggr Auto PGA PGA Mem W/A PGA W/A W/A W/A Global Mem
Target(M) Target(M) Alloc(M) Used(M) Mem Mem Mem Bound(K)
- --------- --------- ---------- ---------- ------ ------ ------ ----------
B 5,000 4,134 770.5 48.8 6.3 100.0 .0 102,400
E 5,000 4,130 798.0 61.9 7.8 100.0 .0 102,400
-------------------------------------------------------------
PGA Aggr Target Histogram for DB: SHESTATE Instance: rac2 Snaps: 7174 -7202
-> Optimal Executions are purely in-memory operations
Low High
Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- ------------- ------------ ------------
8K 16K 73,260 73,260 0 0
16K 32K 8,671 8,671 0 0
32K 64K 2,804 2,804 0 0
64K 128K 2,830 2,830 0 0
128K 256K 972 972 0 0
256K 512K 358 358 0 0
512K 1024K 34,594 34,594 0 0
1M 2M 879 879 0 0
2M 4M 802 802 0 0
4M 8M 201 201 0 0
8M 16M 160 160 0 0
16M 32M 32 32 0 0
32M 64M 1 1 0 0
128M 256M 1 0 1 0
256M 512M 4 0 4 0
-------------------------------------------------------------
PGA Memory Advisory for DB: SHESTATE Instance: rac2 End Snap: 7202
-> When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value
where Estd PGA Overalloc Count is 0
Estd Extra Estd PGA Estd PGA
PGA Target Size W/A MB W/A MB Read/ Cache Overalloc
Est (MB) Factr Processed Written to Disk Hit % Count
---------- ------- ---------------- ---------------- -------- ----------
625 0.1 9,043,825.9 486,224.9 95.0 0
1,250 0.3 9,043,825.9 410,356.0 96.0 0
2,500 0.5 9,043,825.9 358,390.9 96.0 0
3,750 0.8 9,043,825.9 358,390.9 96.0 0
5,000 1.0 9,043,825.9 353,294.2 96.0 0
6,000 1.2 9,043,825.9 329,154.4 96.0 0
7,000 1.4 9,043,825.9 329,154.4 96.0 0
8,000 1.6 9,043,825.9 329,154.4 96.0 0
9,000 1.8 9,043,825.9 329,154.4 96.0 0
10,000 2.0 9,043,825.9 329,154.4 96.0 0
15,000 3.0 9,043,825.9 329,154.4 96.0 0
20,000 4.0 9,043,825.9 329,154.4 96.0 0
30,000 6.0 9,043,825.9 329,154.4 96.0 0
40,000 8.0 9,043,825.9 329,154.4 96.0 0
-------------------------------------------------------------
Enqueue activity for DB: SHESTATE Instance: rac2 Snaps: 7174 -7202
-> Enqueue stats gathered prior to 9i should not be compared with 9i data
-> ordered by Wait Time desc, Waits desc
Avg Wt Wait
Eq Requests Succ Gets Failed Gets Waits Time (ms) Time (s)
-- ------------ ------------ ----------- ----------- ------------- ------------
UL 67,407 17,341 50,053 9,114 .51 5
TT 13,577 13,577 0 4,497 .48 2
CF 52,489 52,489 0 250 .81 0
US 284 284 0 269 .38 0
FB 231 231 0 191 .45 0
TA 109 109 0 107 .49 0
TX 97,114 97,155 0 60 .65 0
IR 42 42 0 7 .43 0
JQ 1 1 0 1 2.00 0
HW 80 80 0 1 1.00 0
TM 279,849 279,847 0 5 .00 0
WL 6 6 0 2 .00 0
DR 18 18 0 1 .00 0
-------------------------------------------------------------
Rollback Segment Stats for DB: SHESTATE Instance: rac2 Snaps: 7174 -7202
->A high value for "Pct Waits" suggests more rollback segments may be required
->RBS stats may not be accurate between begin and end snaps when using Auto Undo
managment, as RBS may be dynamically created and dropped as needed
Trans Table Pct Undo Bytes
RBS No Gets Waits Written Wraps Shrinks Extends
------ -------------- ------- --------------- -------- -------- --------
0 16,558.0 0.00 0 0 0 0
56 550,537.0 0.01 28,771,492 34 5 20
57 140,541.0 0.00 2,609,720 1 0 0
58 73,746.0 0.00 2,231,074 6 0 2
59 73,457.0 0.01 4,457,218 10 0 3
60 62,398.0 0.01 2,474,578 5 0 1
61 68,582.0 0.00 1,405,438 3 0 0
62 64,302.0 0.00 2,397,986 5 0 1
63 82,317.0 0.00 2,058,026 4 4 0
64 61,423.0 0.01 1,334,342 1 0 0
65 84,114.0 0.00 2,596,304 5 0 2
-------------------------------------------------------------
Rollback Segment Storage for DB: SHESTATE Instance: rac2 Snaps: 7174 -7202
->Optimal Size should be larger than Avg Active
RBS No Segment Size Avg Active Optimal Size Maximum Size
------ --------------- --------------- --------------- ---------------
0 385,024 0 385,024
56 21,094,400 1,430,396 1,023,533,056
57 9,560,064 3,566,668 235,003,904
58 3,268,608 1,105,347 1,610,735,616
59 5,365,760 1,428,286 100,786,176
60 3,268,608 876,312 167,895,040
61 2,220,032 5,295,713 193,060,864
62 3,268,608 1,480,289 134,340,608
63 3,268,608 14,745,473 275,898,368
64 3,268,608 737,109 99,737,600
65 4,317,184 1,158,292 84,008,960
-------------------------------------------------------------
Undo Segment Summary for DB: SHESTATE Instance: rac2 Snaps: 7174 -7202
-> Undo segment block stats:
-> uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
-> eS - expired Stolen, eR - expired Released, eU - expired reUsed
Undo Undo Num Max Qry Max Tx Snapshot Out of uS/uR/uU/
TS# Blocks Trans Len (s) Concurcy Too Old Space eS/eR/eU
---- -------------- ---------- -------- ---------- -------- ------ -------------
50 8,008 ########## 4,897 2 0 0 0/0/0/0/0/0
-------------------------------------------------------------
Undo Segment Stats for DB: SHESTATE Instance: rac2 Snaps: 7174 -7202
-> ordered by Time desc
Undo Num Max Qry Max Tx Snap Out of uS/uR/uU/
End Time Blocks Trans Len (s) Concy Too Old Space eS/eR/eU
------------ ------------ -------- ------- -------- ------- ------ -------------
09-Jan 17:00 45 ######## 144 2 0 0 0/0/0/0/0/0
09-Jan 16:50 29 ######## 500 1 0 0 0/0/0/0/0/0
09-Jan 16:40 235 ######## 125 1 0 0 0/0/0/0/0/0
09-Jan 16:30 39 ######## 37 2 0 0 0/0/0/0/0/0
09-Jan 16:20 121 ######## 808 1 0 0 0/0/0/0/0/0
09-Jan 16:10 242 ######## 375 1 0 0 0/0/0/0/0/0
09-Jan 16:00 41 ######## 49 1 0 0 0/0/0/0/0/0
09-Jan 15:50 50 ######## 25 1 0 0 0/0/0/0/0/0
09-Jan 15:40 212 ######## 39 1 0 0 0/0/0/0/0/0
09-Jan 15:30 97 ######## 9 2 0 0 0/0/0/0/0/0
09-Jan 15:20 152 ######## 6 1 0 0 0/0/0/0/0/0
09-Jan 15:10 254 ######## 4 2 0 0 0/0/0/0/0/0
09-Jan 15:00 42 ######## 6 2 0 0 0/0/0/0/0/0
09-Jan 14:50 56 ######## 3 1 0 0 0/0/0/0/0/0
09-Jan 14:40 255 ######## 4 2 0 0 0/0/0/0/0/0
09-Jan 14:30 54 ######## 4 2 0 0 0/0/0/0/0/0
09-Jan 14:20 171 ######## 4 2 0 0 0/0/0/0/0/0
09-Jan 14:10 235 ######## 4 1 0 0 0/0/0/0/0/0
09-Jan 14:00 76 ######## 14 2 0 0 0/0/0/0/0/0
09-Jan 13:50 50 ######## 3 1 0 0 0/0/0/0/0/0
09-Jan 13:40 269 ######## 6 1 0 0 0/0/0/0/0/0
09-Jan 13:30 55 ######## 4,897 1 0 0 0/0/0/0/0/0
09-Jan 13:20 119 ######## 4,578 1 0 0 0/0/0/0/0/0
09-Jan 13:10 223 ######## 3,980 1 0 0 0/0/0/0/0/0
09-Jan 13:00 22 ######## 3,360 1 0 0 0/0/0/0/0/0
09-Jan 12:50 22 ######## 2,782 1 0 0 0/0/0/0/0/0
09-Jan 12:40 197 ######## 2,162 1 0 0 0/0/0/0/0/0
09-Jan 12:30 59 ######## 1,564 1 0 0 0/0/0/0/0/0
09-Jan 12:20 494 ######## 981 1 0 0 0/0/0/0/0/0
09-Jan 12:10 1,022 ######## 368 1 0 0 0/0/0/0/0/0
09-Jan 12:00 167 ######## 49 2 0 0 0/0/0/0/0/0
09-Jan 11:50 71 ######## 11 1 0 0 0/0/0/0/0/0
09-Jan 11:40 238 ######## 7 1 0 0 0/0/0/0/0/0
09-Jan 11:30 60 ######## 14 1 0 0 0/0/0/0/0/0
-------------------------------------------------------------
Latch Activity for DB: SHESTATE Instance: rac2 Snaps: 7174 -7202
->"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
willing-to-wait latch get requests
->"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
->"Pct Misses" for both should be very close to 0.0
Pct Avg Wait Pct
Get Get Slps Time NoWait NoWait
Latch Requests Miss /Miss (s) Requests Miss
------------------------ -------------- ------ ------ ------ ------------ ------
Consistent RBA 76,568 0.0 0 0
FAL request queue 18 0.0 0 0
FAL subheap alocation 8 0.0 0 0
FIB s.o chain latch 36 0.0 0 0
FOB s.o list latch 2,717 0.0 0 0
KCL bast context freelis 1,962 0.0 0 0
KCL freelist parent latc 319,610 0.1 0.0 0 0
KCL gc element parent la 783,128 0.0 0.0 0 99,119 0.0
KCL name table parent la 117,625 0.0 0 98,318 0.0
KJC message pool free li 67,207 0.3 0.0 0 11,897 0.0
KJCT flow control latch 258,684 0.3 0.0 0 57,496 0.2
SQL memory manager latch 18 0.0 0 10,498 0.0
SQL memory manager worka 839,982 0.0 0.0 0 0
active checkpoint queue 23,665 0.0 0.0 0 0
alert log latch 28 0.0 0 0
archive control 2,292 0.0 0 0
archive process latch 649 0.0 0 0
cache buffer handles 86,733 0.0 0 0
cache buffers chains 653,357,839 0.0 0.0 0 446,472 0.0
cache buffers lru chain 35,063 0.0 0 288,940 0.0
channel handle pool latc 4,384 0.0 0 0
channel operations paren 173,978 0.0 0 0
checkpoint queue latch 3,927,618 0.0 0.0 0 22,764 0.0
child cursor hash table 142,244 0.0 0 0
dml lock allocation 403,452 0.1 0.0 0 0
dummy allocation 4,388 0.0 0 0
enqueue hash chains 3,516,671 0.0 0.0 0 0
enqueues 1,836,826 0.0 0.0 0 0
event group latch 2,193 0.0 0 0
gcs opaque info freelist 265,846 2.2 0.0 0 0
gcs resource freelist 1,598,585 2.6 0.0 0 0
gcs resource hash 2,213,736 0.2 0.0 0 0
gcs shadows freelist 1,822,181 1.8 0.0 0 0
ges caches resource list 467,312 0.3 0.0 0 590,395 0.4
ges deadlock list 31,616 0.0 0.0 0 20 0.0
ges domain table 760,174 0.0 0 0
ges enqueue table freeli 973,163 0.0 0.0 0 0
ges group parent 664,017 0.0 0.0 0 0
ges group table 891,886 0.0 0.0 0 0
End of Report
