Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> help me to diagonose our databae
We just implemented 9i RAC on Suse Linux, which we have not put into
production yet except imported some data, but I began to see a lot of
waits. Colud some body help me to point out what setting is wrong, or where
should I check to see?
Thanks
SQL> select event,total_waits as waits,total_timeouts as timeouts, time_waited ,round(average_wait*10)/10 As avgwait from v$system_event where event not in ('client message','rdbms ipc message','pmon timer', 'smon timer','pipe get','SQL*Net message from client')
EVENT WAITS TIMEOUTS TIME_WAITED AVGWAIT ------------------------------ ---------- ---------- ----------- ---------- gcs remote message 54447818 28197508 65657791 1 db file sequential read 19136069 0 12100691 1 global cache cr request 10772462 259 357506 0 ges remote message 7485359 6689435 33042691 4 SQL*Net message to client 5993655 0 2303 0 SQL*Net message to dblink 1012602 0 549 0 SQL*Net message from dblink 1012602 0 298901 0 KJC: Wait for msg sends to com 903094 5 11483 0plete
undo segment extension 873825 873819 499 0 SQL*Net more data from client 529344 0 11442 0 CGS wait for IPC msg 515182 514927 866 0 control file sequential read 486031 0 27294 0 ksxr poll remote instances 466581 363792 554 0 SQL*Net more data to client 418399 0 56927 0 db file scattered read 403256 0 180440 0 direct path read 355946 0 487 0 enqueue 253534 90604 282519 1 log file parallel write 220020 219922 346 0 global cache open x 169154 11 7279 0 latch free 152874 26213 20689 0 global cache s to x 134195 1 623 0 PX Deq: reap credit 113138 113137 223 0 control file parallel write 111346 0 26124 0 DFS lock handle 95698 72089 103363 1 PX Idle Wait 76343 74350 18468664 242 db file parallel write 64012 27205 150 0 row cache lock 18537 36 6168 0 direct path write 17855 0 25 0 library cache lock 14633 280 3826 0 library cache pin 11199 0 409 0 global cache open s 9982 0 219 0 wait for stopper event to be i 3653 3601 33533 9ncreased
log file sync 3035 7 1366 0 rdbms ipc reply 2321 4 1254 1 global cache null to x 1284 9 1367 1 LGWR wait for redo copy 1123 36 34 0 SQL*Net break/reset to client 954 0 47128 49 local write wait 709 0 123 0 global cache null to s 339 3 218 1 log buffer space 255 36 7974 31 log file switch completion 190 4 1763 9 log file sequential read 181 0 152 1 log file single write 181 0 10 0 db file parallel read 173 0 129 1 buffer busy waits 169 53 13 0 name-service call wait 133 125 6521 49 ges cgs registration 114 114 2241 20 PX Deq: Txn Recovery Start 89 0 723 8 lock deadlock retry 72 72 0 0 inactive session 60 59 5908 98 ges lmd/lmses to freeze in rcf 59 59 172 3g - mrcvr
ges2 LMON to wake up LMD - mrc 57 57 167 3 vr
cr request retry 48 48 1 0 kjctssqmg: quick message send 23 4 1 0wait
free buffer waits 20 4 810 41 process startup 15 2 390 26 global cache busy 9 1 196 22 ges2 LMON to wake up lms - mrc 6 6 17 3vr 2
ges global resource directory 3 2 400 133 to be unfrozen
ges reconfiguration to start 3 3 9 3 ges LMD to inherit communicati 2 1 10 5on channels
ges lmd/lmses to unfreeze in r 2 2 5 3 cfg - mrcvr
PX Deq: Signal ACK 2 2 1 1 wait list latch free 1 0 2 2 wait for tmc2 to complete 1 1 2 2 control file single write 1 0 0 0 control file heartbeat 1 1 399 399 instance state change 1 0 2 2 PX Deq: Join ACK 1 1 2 2 buffer deadlock 1 1 0 0 refresh controlfile command 1 0 1 1 ges global resource directory 1 1 3 3to be frozen
reliable message 1 0 0 0Received on Sat Aug 31 2002 - 07:02:40 CDT