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

Home -> Community -> Usenet -> c.d.o.server -> Re: Too many Archive log files

Re: Too many Archive log files

From: Alex Hudghton <alex_at_alenda.NOSPAM!.freeserve.co.uk>
Date: 2000/07/20
Message-ID: <39771767.27013553@news.freeserve.net>#1/1

On Wed, 19 Jul 2000 18:54:46 +1000, "Howard J. Rogers" <howardjr_at_www.com> wrote:

<<snip>>
>
>As a general rule of thumb, you should be log switching around once an hour,
>or maybe every half hour (though it's difficult to be precise, because it
>depends so heavily on the nature of your database).
>

Sorry Howard, but you can't have 'general rules of thumb' for this stuff.

I have two systems running the same application, one switches every 40mins - 1 hour because it has 15 users. The other switches every minute because it has 130 users. The log files are the same size in both cases

Regards

Alex

<<snip>> Received on Thu Jul 20 2000 - 00:00:00 CDT

Original text of this message

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