Re: Scalable Performace - Inserts/Updates

According to the Oracle8 DBA Handbook by Kevin Loney, page 86, "Each database must have at least two online redo log files available to it. The database will write to one log file in a sequential fashion until it is filled, then it will start writing to the second redo log file."

This is especially true if you are running in Archive mode. If there is only one redo log group as you have suggested, then you will have to wait for ARCH to finish archiving the redo log group before you can write to it again. If there is activity on you db, and after the redo log fills and needs archiving you will ALWAYS receive the "checkpoint not complete" message while ARCH is copying your one and only redo log group.

Thanks,
Brian

Nuno Souto wrote:
>
> On Tue, 19 Dec 2000 14:06:05 GMT, Brian Peasland
> <peasland_at_edcmail.cr.usgs.gov> wrote:
>
> >
> >> And if your DBA insists on having more than one redo log group, fire
> >> him/her! Mirror by hardware, not software!
> >
> >Better yet, fire the person who wrote this. Oracle requires a MINIMUM of
> >two redo log groups! So how can you have only one?
> >
>
>
> No it doesn't.
>
> Cheers
> Nuno Souto
> nsouto_at_bigpond.net.au.nospam
> http://www.users.bigpond.net.au/the_Den/index.html
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================