Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: [Q] wait time on stat

Re: [Q] wait time on stat

From: Mladen Gogala <mgogala_at_adelphia.net>
Date: Wed, 28 Jan 2004 12:24:26 -0800
Message-ID: <F001.005DE4C0.20040128122426@fatcity.com>


Increase redo logs to 250M each. You're checkpointing.

On 01/28/2004 03:09:26 PM, dba1 mcc wrote:
> WE have ORACLE 9.2.0.3 database run under Win2000. I
> run "statspack" and found "Top 5 timed event". Look
> like "control file parallel write " and "redo file
> parallel write " take lots time. How to fix?
>
>
>
>
>
> Top 5 Timed Events
> ~~~~~~~~~~~~~~~~~~
> % Total
> Event
> Waits Time (s) Ela Time
> --------------------------------------------
> ------------ ----------- --------
> control file parallel write
> 5,499 1,141 90.37
> CPU time
> 97 7.70
> log file parallel write
> 1,305 12 .95
> db file parallel write
> 162 6 .44
> log file switch completion
> 10 2 .16
>
> -------------------------------------------------------------
> Wait Events for DB: 9IDEV Instance: 9idev Snaps: 5
> -6
> -> s - second
> -> cs - centisecond - 100th of a second
> -> ms - millisecond - 1000th of a second
> -> us - microsecond - 1000000th of a second
> -> ordered by wait time desc, waits desc (idle events
> last)
>
>
> Avg
>
> Total Wait wait Waits
> Event Waits Timeouts
> Time (s) (ms) /txn
> ---------------------------- ------------ ----------
> ---------- ------ --------
> control file parallel write 5,499 0
> 1,141 207 211.5
> log file parallel write 1,305 1,299
> 12 9 50.2
> db file parallel write 162 0
> 6 34 6.2
> log file switch completion 10 0
> 2 204 0.4
> control file sequential read 3,827 0
> 2 0 147.2
> db file sequential read 176 0
> 1 7 6.8
> direct path write 92 0
> 1 6 3.5
> log file sync 14 0
> 0 33 0.5
> log file single write 20 0
> 0 13 0.8
> log file sequential read 35 0
> 0 6 1.3
> direct path read 92 0
> 0 2 3.5
> SQL*Net break/reset to clien 44 0
> 0 0 1.7
> SQL*Net more data to client 7 0
> 0 0 0.3
> async disk IO 4 0
> 0 0 0.2
> virtual circuit status 6,826 496
> 19,650 2879 262.5
> wakeup time manager 530 530
> 19,179 36187 20.4
> SQL*Net message from client 6,457 0
> 12,084 1871 248.3
> jobq slave wait 402 381
> 1,227 3051 15.5
> SQL*Net message to client 6,458 0
> 0 0 248.4
>
> -------------------------------------------------------------
> Background Wait Events for DB: 9IDEV Instance: 9idev
> Snaps: 5 -6
> -> ordered by wait time desc, waits desc (idle events last)
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free web site building tool. Try it!
> http://webhosting.yahoo.com/ps/sb/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: dba1 mcc
> INET: mccdba1_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).
>

-- 
Mladen Gogala
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: mgogala_at_adelphia.net

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 Wed Jan 28 2004 - 14:24:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US