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 <ktsay_at_mailbox.sjc2.mfn.com> 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: kirtikumar_deshpande_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Tue May 27 2003 - 22:19:42 CDT
