Database Administration (MOSC)

MOSC Banner

Checkpoint not complete in alert log file

edited Mar 9, 2010 3:46AM in Database Administration (MOSC) 10 commentsAnswered
 Hi,
I'm seeing "Private strand flush not complete" and "Checkpoint not complete" in the Oracle 11g database alert.log file. As my understanding "Private strand flush not complete" is similar to the “checkpoint not complete” message and can be also handled that way! Should I consider increase the size of the redo logs or should add more of them? Thank you,
> Check the redo log size
>
> SELECT group# "GROUP",
> bytes "SIZE",
> status "STATUS"
> FROM v$log;


Result:

GROUP SIZE STATUS
---------- ---------- ----------------
1 31457280 INACTIVE
2 31457280 CURRENT
3 31457280 INACTIVE
4 31457280 INACTIVE


> SELECT ROUND(AVG(1440 * (b.first_time - a.first_time)), 0) "Log switch
> time - minutes"

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