log_checkpoint_... parameters changed in 8.1+ so these
no longer control when a full checkpoint occurs, they
are more used to keep blocks "up to date" with the
redo log stream.
Maybe look at having some larger redo logs to lower
your switch frequency, and see if you are doing
bundles of commits - a common cause of log file syncs.
How long was your statspack interval? 5239seconds of
waiting could be problem or not, dependent on the
timescale you're comparing against
hth
connor
- oraora oraora <oraoraora_at_rediffmail.com> wrote:
> Guys,
>
> my DB is on 8.1.6.0.0. / Win2k.
> I have log switch every 5 minutes.
> my redo log file size is 5MB.
>
> LOG_CHECKPOINT_INTERVAL = 10000
> LOG_CHECKPOINT_TIMEOUT = 1800
>
> my statspack report shows
>
>
> Avg
> Total Wait wait
> Waits
> Event waits Timeouts Time(cs) (ms)
> /txn
> ------------------ ----- ------- ----------
> -----
> log file sync
> 2,468,395 703 523,921 2
> 1.1 log file
> switch completion
> 2,570 210 48,112 187
> 0.0
>
> Will increasing my log file size reduce the above
> contention ???
>
> IF SO ...........
> I would like to increase my redo log file size from
> 5MB to 30MB so
> that log switch
> occurs every 30 mins. now what should be the value
> of
> LOG_CHECKPOINT_INTERVAL ? Oracle suggets it be
> greater than log
> file size . should it be 30 MB / 512 ?
> 512 is my OS block size.
> or should i just increase it to 1000000 ??
>
> Kindly throw some light on this guys.
> TIA.
>
> Give your Company an email address like
> ravi @ ravi-exports.com. Sign up for Rediffmail Pro
> today!
> Know more. http://www.rediffmailpro.com/signup/
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: oraora oraora
> INET: oraoraora_at_rediffmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> 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).
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net
"Remember amateurs built the ark - Professionals built the Titanic"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Aug 07 2002 - 08:18:24 CDT