log_archive_interval

Hi there,

We are running Oracle 9.2 on Window 200 environment. I found that the log_archive_interval for our database is set to 0. Somehow, I read some book, saying that we should never set that parameter to 0.

In the normal hour of the day, I can see the redo log files get switched at around every 2 hours. When the daily script to purge some tables is run, the log files switch within a minute for two or three times. The purging deletes about 20K rows of data. I have 3 log groups; each log file is 100M in size.

The question is: do I need to specify a value for the log_archive_interval ? The Two hour log switching seems to be too long.

Also are 3 log groups good enough to prevent the situation that the LGWR has to wait for ARC process to finish ? I plan to map a drive through network as an optional destination for the Archive Log destination. I noticed in this news group that some user use 4 log group for their system, I wonder under what situation the system need to configure so.

Thanks for the advise in advance.

JW Received on Tue Nov 30 2004 - 00:44:05 CST