Re: select question

From: music4 <music4_at_163.net>
Date: Tue, 18 Mar 2003 16:32:31 +0800
Message-ID: <b56ljp$dl8@netnews.proxy.lucent.com>

Sybrand,

Thanks for your answer.

I checked redo log files just now, I have 5 redo log files, and each one is 20M. Are they big enought? Or I still need to add more redo log files.

Thanks,
Evan

> On Tue, 18 Mar 2003 15:33:45 +0800, "music4" <music4_at_163.net> wrote:
>
> >Do you have any more idea?
>
>
> Most likely your server is badly tuned, your online redo log files are
> way too small (the default is 200k, which is ridiculous nowadays) and
> you are switching log files like hell, which would be easily pertinent
> from v$log_history.
> Please try to *resolve* the *issue* instead of just *fighting
> symptoms*
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Tue Mar 18 2003 - 02:32:31 CST