Re: select question

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 18 Mar 2003 10:34:49 +0100
Message-ID: <rvpd7v032r5qo4pa6djgnthdbb9onv0ogk@4ax.com>

On Tue, 18 Mar 2003 16:32:31 +0800, "music4" <music4_at_163.net> wrote:

>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
>

Evan,
This depends above all on how often you are switching logs. During a switch there is NO write activity.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Mar 18 2003 - 03:34:49 CST