All those documents are correct. PMON just waits while there is no work for it to do. This wait event does not affect database performance.
- Kirti --- Kevin Tsay <[EMAIL PROTECTED]> wrote: > Dear Lister: > > I'm using one of Steve Adams's scripts to break down > the components of foreground response time. > > I found the pmon timer is taking about 63.59% out of > other components. > Although some of the tuning documents suggesting > ignore this event but > it still took a lots of time. > > Any thoughts ? > > Thanks > > --Kevin > > SQL> @response_time_breakdown.sql > > MAJOR MINOR WAIT_EVENT > SECONDS > PCT > -------- ------------- > ---------------------------------------- > ------------ > ------ > CPU time parsing n/a > 304 > .00% > reloads n/a > 600 > .00% > execution n/a > 153134 > .00% > > disk I/O normal I/O db file sequential read > 5582765477 > 21.15% > full scans db file scattered read > 352191089 > 1.33% > direct I/O direct path read > 528732282 > 2.00% > direct path write > 14689646 > .06% > direct path write (lob) > 7054 > .00% > other I/O db file parallel read > 6502322 > .02% > control file parallel write > 2702081 > .01% > > MAJOR MINOR WAIT_EVENT > SECONDS > PCT > -------- ------------- > ---------------------------------------- > ------------ > ------ > disk I/O other I/O control file single write > 2354364 > .01% > control file sequential read > 2279481 > .01% > db file single write > 226882 > .00% > log file sequential read > 143206 > .00% > control file heartbeat > 40064 > .00% > > waits DBWn writes rdbms ipc reply > 1398034 > .01% > free buffer waits > 797265 > .00% > write complete waits > 50271 > .00% > local write wait > 2587 > .00% > LGWR writes log buffer space > 10779368 > .04% > > MAJOR MINOR WAIT_EVENT > SECONDS > PCT > -------- ------------- > ---------------------------------------- > ------------ > ------ > waits LGWR writes log file switch completion > 1383243 > .01% > enqueue locks enqueue > 5205620 > .02% > other locks PX Deq Credit: send blkd > 126584654 > .48% > PX Deq Credit: need buffer > 22686486 > .09% > PX qref latch > 6746743 > .03% > buffer busy waits > 3070154 > .01% > latch free > 738973 > .00% > library cache pin > 19493 > .00% > undo segment extension > 988 > .00% > library cache lock > 301 > .00% > library cache load lock > 100 > .00% > > MAJOR MINOR WAIT_EVENT > SECONDS > PCT > -------- ------------- > ---------------------------------------- > ------------ > ------ > waits other locks buffer deadlock > 1 > .00% > > latency commits log file sync > 7397468 > .03% > network SQL*Net more data to client > 22293948 > .08% > SQL*Net more data from client > 5173274 > .02% > SQL*Net message to client > 340244 > .00% > SQL*Net break/reset to client > 8152 > .00% > SQL*Net more data to dblink > 23 > .00% > SQL*Net message to dblink > 23 > .00% > process ctl process startup > 108286 > .00% > PX Deq: Signal ACK > 100629 > .00% > > MAJOR MINOR WAIT_EVENT > SECONDS > PCT > -------- ------------- > ---------------------------------------- > ------------ > ------ > latency process ctl PX Deq: Join ACK > 6684 > .00% > PX Deq: Msg Fragment > 1002 > .00% > global locks wait for a undo record > 9470 > .00% > misc pmon timer > 16780800644 > 63.59% > async disk IO > 1981734344 > 7.51% > jobq slave wait > 919593160 > === message truncated === __________________________________ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
