Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Poor Performance on Oracle9i - 9.2.0.7
Hello, Beko.
The results are:
refresh controlfile command 1 0 buffer deadlock 5 0 recovery read 2 0 BFILE get length 12 0 BFILE internal seek 81 0 BFILE closure 19 0 instance state change 2 0 undo segment extension 2555 1 SQL*Net more data to dblink 68 1 PX Deq: Signal ACK 1 2 checkpoint completed 1 3 kksfbc child completion 2 3 PX Deq: Join ACK 5 4 wait list latch free 5 9 slave TJ process wait 6 10 BFILE open 19 11 log file single write 30 19 BFILE read 245 29 SQL*Net message to dblink 50833 38 reliable message 1 55 row cache lock 234 94 buffer latch 1 98 sort segment request 1 99 db file single write 761 114 LGWR wait for redo copy 6187 264 local write wait 64 309 control file sequential read 12624 322 wait for stopper event to be increased 35 350 control file heartbeat 1 391 inactive session 5 492 HS message to agent 220 496 single-task message 47 549 process startup 48 640 log file switch completion 120 891 rdbms ipc reply 1031 1025 queue messages 4 1956 write complete waits 21 2073 library cache load lock 165 3756 direct path write (lob) 5829 4079 library cache pin 2138 5040 async disk IO 9341 5344 PX Deq: Txn Recovery Start 40 7335 SQL*Net break/reset to client 57835 7587 SQL*Net message to client 10334642 10889 control file parallel write 5401 12832 db file parallel read 4601 14945 direct path read (lob) 40807 15100 SQL*Net more data to client 949685 15454 SQL*Net message from dblink 50833 15702 log file sequential read 4669 22723 direct path read 60661 38085 SQL*Net more data from dblink 180900 55651 buffer busy waits 297238 84929 direct path write 35212 102555 enqueue 1590 130010 latch free 219574 290930 log file parallel write 354903 342771 SQL*Net more data from client 83295 348647 db file parallel write 71990 401167 log file sync 115297 521389 PX Idle Wait 3019 591315 PL/SQL lock timer 415 642077 db file scattered read 3248904 834524 wakeup time manager 436 1182060 smon timer 5619 1206805 pmon timer 4304 1238267 jobq slave wait 14425 3604979 db file sequential read 20479048 4342690 rdbms ipc message 313526 9989699 pipe get 38824 13604893 SQL*Net message from client 10333655 434317043 ######################################################### PL/SQL lock timer 1 SQL*Net message from client 1237 SQL*Net message to client 1 SQL*Net more data from client 1 db file parallel write 1 db file sequential read 7 jobq slave wait 3 pipe get 11 pmon timer 1 rdbms ipc message 8 smon timer 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1 wakeup time manager 1
Thank you.
Edson
Received on Wed May 10 2006 - 07:47:52 CDT