Re: How to tune "redo log space request"?

From: Michael Bialik <michael_bialik_at_my-deja.com>
Date: Sat, 21 Oct 2000 06:58:29 GMT
Message-ID: <8sreqk$kfd$1@nnrp1.deja.com>

Hi.
Try increasing log_buffer to 1048576 ( 1Mb ).

HTH. Michael.

In article <01c03ae1$35d9e960$239e15c2_at_w95luca>, "Luca Minudel" <luca.minudel_at_nline.it> wrote:
> I've got a problem with an Oracle instance.
> The instance has a "redo log space request" (and a consequent "redo
log=20
> space wait time") every time there is a redo log file switch.
>
> The redo log files are huge (32MB) and are many (12 redo log groups
of 1 =
>
> file each). They are on 2 different fast disks/controllers/channels.
> The log_buffer is set to 262144.
>
> As I know there should not be "redo log space requests". Isn't it?
> How can I avoid them?
> How can I find theyr cause?
>
> TIA
> ___________________________________________________
> Luca Minudel software designer
> Italy Conegliano (TV)
> e-mail luca.minudel_at_nline.it
> http://www.geocities.com/SiliconValley/Vista/4041
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Oct 21 2000 - 01:58:29 CDT