RE: log_buffer 10gr2
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "ujang.jaenudin@xxxxxxxxx" <ujang.jaenudin@xxxxxxxxx>, Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 28 May 2009 09:49:41 -0400
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
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Other related posts: