Discussion :

[elharet]

Bonjour;
est ce que quelqu'un a la liste des wait event d'oracle et de leurs significations, j'ai ici quelques uns que j'ai pris d'un report de statspack et je ne connais pas leurs significations:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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

merci d'avance.

[orafrance]

http://download.oracle.com/docs/cd/B...3.htm#BGGIBDJI