Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question about archive log?
No,
Probably either your redo log files are too small, or you have too few of them, or log_checkpoint_size is incorrect. Do you
experience delays connecting to a database through sqlplus? There can be numerous reasons for that, including incorrect sqlnet
config.
If you could provide the ng with more specific details, either myself or someone would be glad to help you out. In a production
environment archive log is a prerequisitie, and to be considered the Eleventh Commandment in Oracle.
Kind regards,
Sybrand Bakker, Oracle DBA
outlaw2_at_mindspring.com wrote:
> I have a question for those who work with Oracle Database V7 or above with Windows NT.
> Did you ever have a system problem such as performance when you turn on archive log? It seems that whenever I turn on archive
> log. For some reasons, it takes a while to access the database via SQLPlus. Any response will be appreciated except flames.
>
> Thanks,
>
> J.
Received on Mon Jan 18 1999 - 12:54:24 CST