Re: Question about sizing log files

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:<3E8C12A4.2F71_at_yahoo.com>...
> Chuck wrote:
> >
> > We currently have our redo logs set to 20mb and we get an average of 4
> > log switches per minute. Just wondering how high people tend to set redo
> > log sizes on very busy OLTP database. We are currently running 8.1.7.4
> > on Solaris 8 64-bit. We are currently trying to migrate to 9.2.0.1.
> >
> > Thanks for any info,
> > CC
> >
> > -----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
> > http://www.newsfeed.com The #1 Newsgroup Service in the World!
> > -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----
>
> Big is beautiful... In 9i you've got the archive_lag parameter, but I
> like the concept of massive log files and then a job to switch them at
> regular intervals.
>
> Then its not "My logs switch roughly so often", its "I know my logs
> switch exactly 2 times per hour at this time"
>
> hth
> connor

I could not agree more.
a switch logfile proc with trunc() in the dbms_job.what is a wonderful thing. just beware of the current bug in 9.2 whereby dbms_jobs might stop running.

Paul Received on Thu Apr 03 2003 - 10:04:43 CST