Re: log_buffer Value setting NOT effective ?

Hello,

The log_buffer setting is rounded up to nearest granule size. Have a look at Metalink Note:351857.1.

cheers,

jason.

--
http://jarneil.wordpress.com

On 21 May 2008, at 21:40, VIVEK_SHARMA wrote:



> Folks

>

> Even though log_buffer is set to 1M, on Database Startup it is  

> automatically getting reset to 14MB (shown below)

> NOTE – sga_target=0

> NOTE – Online Redo logfile size = 1 GB

>

> Oracle 10.2.0.3

> HP-UX 11.31

>

> Any ideas why?

>

> Cheers & Thanks

>

> Vivek

>

> P.S.

>

> SQL> startup

> ORACLE instance started.

>

> Total System Global Area 3254779904 bytes

> Fixed Size                  2048904 bytes

> Variable Size            1090522232 bytes

> Database Buffers         2147483648 bytes

> Redo Buffers               14725120 bytes

> Database mounted.

> Database opened.

> **************** CAUTION - Disclaimer *****************

> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION  

> intended solely

> for the use of the addressee(s). If you are not the intended  

> recipient, please

> notify the sender by e-mail and delete the original message.  

> Further, you are not

> to copy, disclose, or distribute this e-mail or its contents to any  

> other person and

> any such actions are unlawful. This e-mail may contain viruses.  

> Infosys has taken

> every reasonable precaution to minimize this risk, but is not liable  

> for any damage

> you may sustain as a result of any virus in this e-mail. You should  

> carry out your

> own virus checks before opening the e-mail or attachment. Infosys  

> reserves the

> right to monitor and review the content of all messages sent to or  

> from this e-mail

> address. Messages sent to or from this e-mail address may be stored  

> on the

> Infosys e-mail system.

> ***INFOSYS******** End of Disclaimer ********INFOSYS***



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