Database Administration (MOSC)

MOSC Banner

frequent Log Switches, Smon 100% cpu but no users in the database

edited Mar 4, 2013 4:34PM in Database Administration (MOSC) 8 commentsAnswered
Hi.

I have 1 oracle 11.1.0.7 instance on a redhat linux 5 which continues log switching every <2 minutes even though there are no active users on the system.

I have increased the size and number of log files to prevent the Checkpoint failed errors and seemed to have helped a little. I now have 24 redo logfiles 10 of them are 54MB in size, 14 256MB.

With this number the majority is active, 1 current and 1 inactive which at least prevents the Checkpoint not complete messages in the alert log but I have no idea which process is generating the log entries as there are no transactions happening.

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