Database Administration (MOSC)

MOSC Banner

log file sync

Hi,

On 11.2.0.4 on AIX, database is slow.

I ran AWR in which I have:


Then for me the problem might be log file sync (then redolog switching) or number of commits. Am I right?

For logs I ran:


Is 1354 minutes too much?

Size of redlogs are :

Should I create larger redo log file?

Otherwise what should I do for commits? How to find average number of commits?

Thanks.

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