Database - RAC/Scalability (MOSC)

MOSC Banner

DB log buffer not increasing

edited Mar 19, 2016 5:06AM in Database - RAC/Scalability (MOSC) 2 commentsAnswered

log_buffer does not get updated after an oracle instance cycle.

i'm trying to increase the log buffer size however the database is not taking the change.

i'm used this syntax

alter system set LOG_BUFFER = 8388608 scope=spfile sid='*';

This appeared to take w/o error and i cycled the database.

Upon cycling the database i find out that the log_buffer setting is back to being 8355840.

i need help on how to fix this

11.2.0.4 Enterprise Edition

RAC, ASM, AIX7100-03-04-1441

Thanks

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center