RE: log_buffer 10gr2

From: QuijadaReina, Julio C <>
Date: Thu, 28 May 2009 10:01:49 -0400
Message-ID: <>

14MB for log buffer appears to be the default I've seen when creating a database through dbca.

Julio Quijada

-----Original Message-----

From: [] On Behalf Of Bobak, Mark Sent: Thursday, May 28, 2009 9:50 AM
To:; Oracle Discussion List Subject: RE: log_buffer 10gr2

Ok, first, take a step back.

What is motivating you to look at log_buffer in the first place? Why do you think it needs to be adjusted? Starting w/ 10g, the log_buffer is maintained by Oracle, and should not need to be adjusted. (See MetaLink Doc ID 351857.1.) What is the current value of _log_io_size? Why do you think you need to adjust it?

Main question:
What is it that is leading you to believe that log_buffer and _log_io_size need to be adjusted?


-----Original Message-----

From: [] On Behalf Of Ujang Jaenudin Sent: Thursday, May 28, 2009 6:14 AM
To: Oracle Discussion List
Subject: log_buffer 10gr2

dear all,

I have on solaris sparc,
when trying to decrease log_buffer, it could not be done.

always keep 14MB, sga is 3.5GB
I want to decrease it to 1MB

according to metalink note. 351857.1
it is expected behavior.

so, is it save to change _log_io_size to 1MB ?


thanks and regards
ujang | oracle dba | mysql dba


-- Received on Thu May 28 2009 - 09:01:49 CDT

Original text of this message