Database Administration (MOSC)

MOSC Banner

Log switch occuring very frequently

edited Jan 6, 2009 3:37AM in Database Administration (MOSC) 7 comments
 Hi,
I am using 10.2.0.4. The problem i am facing is that the log switch is occuring frequently. The size of my redo logs are 100MB but my archive files are hardly 50 - 60 MB in size the archiver is not waiting for the logfile to complete. The parameters of log_checkpoint in my db are

log_checkpoint_timeout=0
log_checkpoint_interval=0

Any ideas?
 

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