Re: log_buffer Value setting NOT effective ?

From: jason arneil <jason.arneil_at_gmail.com>
Date: Wed, 21 May 2008 21:50:50 +0100
Message-Id: <E7CEF883-D151-4B78-A347-160435DF1C1F@gmail.com>


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
Received on Wed May 21 2008 - 15:50:50 CDT

Original text of this message