Re: [Q] wait time on stat

How did you determine the size of the logs?

Or are you just guessing that they are significantly less than 250m?

Could just be a very busy database that needs redo and controlfile on faster disk.

Jared

On Wed, 2004-01-28 at 12:24, Mladen Gogala wrote:
> 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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.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).