alter system set log_buffer is doesn't work

[Former Member]

Hello

I use note 830576 - setting log_buffer = 1048576. Curent value 14501888:

alter system set log_buffer=1048576 scope=spfile;

Do restartsap and show parameter again

NAME TYPE VALUE

-

---

-

---

-

---

log_buffer integer 14501888

And when i do shutdown immediate - system is not responce . Do reboot.

regard's

Denis

[former_member204746 · Accepted solution]

perhaps you ar enot using an SPFILE but a pfile. (initSID.ora)

to knw which one you use:

sqlplus "/ as sysdba"

show parameter pfile

if this shows:

NAME TYPE VALUE

-

---

-

---

-

---

spfile string

This means you are using initSID.ora

if this is the case, you simply edit initSID.ora and restart your DB.

[lbreddemann]

Hi Denis,

please see the explanation for this in the note you already mentioned:

<a href="http://service.sap.com/sap/support/notes/830576">830576 - Parameter recommendations for Oracle 10g</a>.

With Oracle 10g you may specify a lower limit to the log buffer by setting the parameter value for log_buffer to some value. But Oracle still will make up the actual size of the log buffer by itself.

KR Lars