| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> wait events
hi girls and boys,
I use the statspack of oracle to tune my database, and i can see in the
table concerning waiting events :
Avg
Total Wait wait
Waits
Event Waits Timeouts Time (cs)
---------------------------- ------------ ---------- ----------- ----- -
-----
control file sequential read 33 0 6
2 33.0
control file parallel write 50 0 4
1 50.0
refresh controlfile command 5 0 2
4 5.0
direct path read 832 0 1 0
832.0
direct path write 644 0 0 0
644.0
log file parallel write 9 0 0
0 9.0
SQL*Net break/reset to clien 4 0 0
0 4.0
file open 4 0 0
0 4.0
LGWR wait for redo copy 1 0 0
0 1.0
log file sync 1 0 0
0 1.0
SQL*Net message from client 84 0 3,042
362 84.0
SQL*Net message to client 84 0 0
0 84.0
-------------------------------------------------------------
Background Wait Events for DB: DBTEST Instance: dbtest Snaps: 1 -
Avg
Total Wait wait
Waits
Event Waits Timeouts Time (cs)
---------------------------- ------------ ---------- ----------- ----- -
-----
control file parallel write 50 0 4
1 50.0
control file sequential read 15 0 2
1 15.0
log file parallel write 8 0 0
0 8.0
LGWR wait for redo copy 1 0 0
0 1.0
rdbms ipc message 171 150 8,514 498
171.0
pmon timer 50 50 2,764
553 50.0
-------------------------------------------------------------
SQL ordered by Gets for DB: DBTEST Instance: dbtest Snaps: 1 -
2
So i would like to know if anybody can tell what i could to do to decrease waiting times.
Thanks
See you
Fly13
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Oct 12 2000 - 05:03:20 CDT
 |
 |