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:
FolksEven 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 theInfosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS***