Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Too many Archive log files
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
![]() |
![]() |