Database Tuning (MOSC)

MOSC Banner

log file synch issue

edited Jan 25, 2016 8:50PM in Database Tuning (MOSC) 10 commentsAnswered

Hi community,

I am facing transient log file synch issue and would like yto know if I am going the right direction while troubleshooting.

AWR :

Top 10 Foreground Events by Total Wait Time

EventWaitsTotal Wait Time (sec)Wait Avg(ms)% DB timeWait Class
log file sync139,03981.7K58881.9Commit
DB CPU 12.8K 12.8
buffer busy waits3,4032208.16492.2Concurrency
db file sequential read2,439,807808.10.8User I/O
log buffer space2747592770.8Configuration
direct path write temp17,520385.622.4User I/O
flashback log file sync9,246270.929.3User I/O
direct path read3,288,2952670.3User I/O
direct path write12,499225.118.2User I/O
SQL*Net message from dblink3,864160.842.2Network

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