Database Tuning (MOSC)

MOSC Banner

V$log status

edited Aug 5, 2015 10:04AM in Database Tuning (MOSC) 5 commentsAnswered

When viewing my v$log status we see five inactive status and one current which we want to see, however during the evening this will change to 3 active 1 current etc.  My AWR report will show log file sync wait the top event.

Once again what we expected.  We know how to fix the problem, and in the process.

My question I am trying to determine how long it's takes to catch up to 5 inactive, and the one current.  I am looking to benchmark before and after I move my redo longs around.

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