1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
| log file sync 9,093 0 166 18 2.6
log file parallel write 8,662 0 108 12 2.4
row cache lock 4,990 4 100 20 1.4
global cache cr request 21,377 10,717 97 5 6.0
global cache null to x 12,466 6,233 88 7 3.5
db file sequential read 3,936 0 45 11 1.1
library cache lock 13,949 33 44 3 3.9
PX Deq Credit: send blkd 914 0 38 42 0.3
global cache s to x 7,585 1,590 38 5 2.1
DFS lock handle 8,582 0 18 2 2.4
buffer busy global cache 253 0 15 61 0.1
buffer busy global CR 153 4 9 57 0.0
control file sequential read 1,744 0 9 5 0.5
ksxr poll remote instances 20,818 13,383 8 0 5.9
control file parallel write 424 0 6 14 0.1
CGS wait for IPC msg 11,880 11,123 6 0 3.3
global cache open x 2,187 1,011 6 3 0.6
SQL*Net more data to client 7,800 0 5 1 2.2
enqueue 1,208 5 5 4 0.3
wait for master scn 924 4 4 4 0.3
buffer busy waits 124 0 3 27 0.0
global cache busy 97 0 3 30 0.0
PX Deq: reap credit 11,000 10,077 3 0 3.1
latch free 2,013 489 3 1 0.6
name-service call wait 36 0 2 48 0.0
global cache null to s 196 99 1 6 0.1
library cache pin 209 0 1 3 0.1
global cache open s 109 57 1 5 0.0
PX Deq Credit: need buffer 7 0 0 42 0.0
LGWR wait for redo copy 61 2 0 1 0.0
KJC: Wait for msg sends to c 31 0 0 1 0.0
SQL*Net break/reset to clien 26 0 0 1 0.0
direct path read 171 0 0 0 0.0
ges inquiry response 2 0 0 1 0.0
lock escalate retry 51 51 0 0 0.0
buffer deadlock 16 15 0 0 0.0
SQL*Net message from client 468,763 0 31,692 68 132.0
PX Idle Wait 8,048 8,048 20,129 2501 2.3
gcs remote message 287,700 19,813 3,338 12 81.0
ges remote message 837,703 356,095 1,278 2 236.0
wakeup time manager 41 41 1,236 30154 0.0
PX Deq: Execution Msg 123 67 205 1664 0.0
SQL*Net message to client 468,757 0 1 0 132.0
SQL*Net more data from clien 1,604 0 1 1 0.5
PX Deq: Table Q Normal 1 0 0 1 0.0 |
