Hi
I am attaching the full list of wait events:
Wait Events for DB: ORCSAW Instance: orcsaw Snaps: 2 -3
-> cs - centisecond - 100th of a second
-> ms - millisecond - 1000th of a second
-> ordered by wait time desc, waits desc (idle events last)
Avg
Total Wait wait
Waits
Event Waits Timeouts Time (cs) (ms)
/txn
---------------------------- ------------ ---------- ----------- ------
------
SQL*Net message from dblink 1,134 0 4,058 36
9.9
db file scattered read 510 0 141 3
4.4
db file sequential read 513 0 126 2
4.5
SQL*Net break/reset to clien 44 0 67 15
0.4
direct path read 247 0 20 1
2.1
log file sync 111 0 17 2
1.0
latch free 40 25 14 4
0.3
direct path write 79 0 13 2
0.7
control file sequential read 37 0 10 3
0.3
refresh controlfile command 6 0 4 7
0.1
log file parallel write 160 0 3 0
1.4
SQL*Net message to dblink 1,133 0 0 0
9.9
SQL*Net more data to client 465 0 0 0
4.0
control file parallel write 233 0 0 0
2.0
db file parallel write 66 0 0 0
0.6
file open 5 0 0 0
0.0
SQL*Net message from client 5,472 0 1,138,103 2080
47.6
SQL*Net message to client 5,471 0 2 0
47.6
-------------------------------------------------------------
i hope this info will help.
thks and regards
clement
Received on Sat Sep 10 2005 - 01:24:40 CDT
