10.2.0.1
winXP
Hi,
At present no external activity is going on in my machine.I queried v$system_event to see the system statistics.I can see some considerable waits.Can you guys give some insight to it?
SQL> select event,total_waits,time_waited,average_wait,event_id from v$system_event
SQL> /
EVENT TOTAL_WAITS TIME_WAITED AVERAGE_WAIT EVENT_ID
---------------------------------------------------------------- ----------- ----------- -----------
pmon timer 5951 1770332 297.48 3539483025
rdbms ipc message 63724 19047738 298.91 866018717
Log archive I/O 7 6 .85 2089793129
class slave wait 2 999 499.42 1055154682
os thread startup 20 42 2.11 86156091
control file sequential read 5404 1918 .35 3213517201
control file parallel write 5986 1462 .24 4078387448
read by other session 3 2 .54 3056446529
recovery read 3 0 0 765902655
log file sequential read 22 161 7.3 549236675
log file single write 7 2 .32 215477332
log file parallel write 388 179 .46 3999721902
latch: redo writing 3 610 203.39 2539661515
log file sync 3 2 .53 1328744198
db file sequential read 4454 7212 1.62 2652584166
db file scattered read 133 400 3.01 506183215
db file single write 7 34 4.83 1307477558
db file parallel write 857 58 .07 1620694733
direct path read 28 5 .18 3926164927
direct path read temp 4 0 0 861319509
direct path write 14 4 .27 885859547
smon timer 62 1671373 26957.62 1403232821
latch: shared pool 1 0 0 2696347763
virtual circuit status 590 1765032 2991.58 3618703989
dispatcher timer 295 1762544 5974.72 4090013609
SQL*Net message to client 29 0 0 2067390145
SQL*Net more data to client 2 0 .02 554161347
SQL*Net message from client 28 23271 831.12 1421975091
Streams AQ: waiting for time management or cleanup tasks 9 351757 39084.12 3702640206
Streams AQ: qmn coordinator idle wait 946 1757954 1858.3 989870553
Streams AQ: qmn slave idle wait 633 1762564 2784.46 1830121438
latch free 322 429 1.33 3474287957
rdbms ipc reply 17 285 16.75 2587381521
reliable message 2 4 2.16 906644781
control file heartbeat 1 399 399.11 40893507
enq: CF - contention 3 286 95.32 1494394835
Wait on stby instance close 5 500 99.99 2486749347
LGWR wait for redo copy 1 0 .01 4266849434
instance state change 1 0 .13 1525267497
Streams AQ: qmn coordinator waiting for slave to start 3 1002 333.84 1565566389
enq: TL - contention 1 2 2.25 2407027636
Regards