Citation:
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
buffer busy waits 17,677,446 312,333 18 43.1 Concurrenc
latch: undo global data 2,927,424 149,898 51 20.7 Other
CPU time 96,163 13.3
latch: cache buffers chains 1,465,590 50,274 34 6.9 Concurrenc
db file sequential read 4,007,624 21,511 5 3.0 User I/O
-------------------------------------------------------------
Citation:
Buffer
Tablespace Subobject Obj. Busy % of
Owner Name Object Name Name Type Waits Capture
---------- ---------- -------------------- ---------- ----- ------------ -------
SIEBEL SIEBEL_DAT S_CAMP_CON TABLE 17,655,116 99.94
SIEBEL SIEBEL_IND S_CAMP_CON_P1 INDEX 5,328 .03
SIEBEL SIEBEL_IND S_CAMP_CON_MKT2_X INDEX 2,270 .01
SIEBEL SIEBEL_IND S_CAMP_CON_M1 INDEX 988 .01
SIEBEL SIEBEL_IND S_CAMP_CON_F8 INDEX 880 .00
-------------------------------------------------------------
Pour votre information il s'agit d'une BD oracle 10.2.0.4 sous un envirenement SOLARIS .