RE: log_buffer 10gr2

  • From: "QuijadaReina, Julio C" <QuijadJC@xxxxxxxxxxxxxxx>
  • To: "Mark.Bobak@xxxxxxxxxxxx" <Mark.Bobak@xxxxxxxxxxxx>, "ujang.jaenudin@xxxxxxxxx" <ujang.jaenudin@xxxxxxxxx>, Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 28 May 2009 10:01:49 -0400

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

Julio Quijada


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Bobak, Mark
Sent: Thursday, May 28, 2009 9:50 AM
To: ujang.jaenudin@xxxxxxxxx; 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?

-Mark

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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 10.2.0.3 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
http://ora62.wordpress.com
--
//www.freelists.org/webpage/oracle-l




--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l


Other related posts: