Bonjour

je constate apres extraction du rapport AWR (une partie est jointe) que j'ai un 'gc buffer busy" élevé.

A quoi correspond ceci?

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
 
Top 5 Timed Events                                         Avg %Total
~~~~~~~~~~~~~~~~~~                                        wait   Call
Event                                 Waits    Time (s)   (ms)   Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
gc buffer busy                    3,500,150      39,286     11   39.7    Cluster
CPU time                                         20,982          21.2           
log file sync                     1,007,278      18,103     18   18.3     Commit
gc cr block busy                    712,553      11,238     16   11.4    Cluster
log file parallel write             433,734       5,431     13    5.5 System I/O
----------------------------------------------------------------------------- 
Wait Class                      Waits  -outs         Time (s)    (ms)      /txn
-------------------- ---------------- ------ ---------------- ------- ---------
Cluster                     5,637,439     .2           58,670      10       7.4
Commit                      1,007,278     .0           18,103      18       1.3
System I/O                    911,062     .0            7,921       9       1.2
Other                       1,752,381   47.5            5,385       3       2.3
Concurrency                   229,785     .1            1,780       8       0.3
Network                    32,275,376     .0              967       0      42.1
User I/O                      201,233     .0              511       3       0.3
Configuration                  11,732    1.4              326      28       0.0
Application                     3,171     .0                7       2       0.0
          -------------------------------------------------------------
merci de votre aide