Database Administration (MOSC)

MOSC Banner

Log buffer to tune

edited Dec 21, 2009 4:17AM in Database Administration (MOSC) 2 commentsAnswered
 Hi ,

In our database we are getting redo buffer allocation retries value very high,

SELECT R.VALUE "Retries",E.VALUE "Entries",R.VALUE/E.VALUE*100 "Percentage"
FROM V$SYSSTAT R,V$SYSSTAT E
WHERE R.NAME = 'redo buffer allocation retries'
AND E.NAME ='redo entries'; 

   Retries    Entries           Percentage
----------        ----------            ----------   
     12285  100971656   .012166781

Could you pls help me how to tune log buffer

log_buffer=14242816

Regards,

Jitender Kr. Lakra
 

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