Defaulty Windows installation usually creates log files of 20M. The
person who posted the problem explicitely mentioned Windows platform.
Size of 20M is so small that the database will start to checkpoint
like crazy when you start using it for real. The number that I gave
is my rule of thumb. It's not to big to frighten the boss (alltogether
just a gig or two) and it's big enough to solve checkpointing problem.
This rule of thumb number is derived from experience. Yes, of course,
I am guessing. There is not enough information to investigate the
problem. I believe that he was asking us to guess. I did.
On 01/28/2004 08:14:25 PM, Jared Still wrote:
> 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).
>
--
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 - 19:54:26 CST
