python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - redo

Oracle database "log file sync" wait event

We are having an issue on our production database where the blocked sessions suddenly spike for a few minutes and everything stops working. Looking at the blocked session history, I can see the log wr...
test-img

Hammad Mansoor

database

oracle

commit

disk

redo

Votes: 0

Answers: 1

Latest Answer

Check out v$active_session_history for the LGWR process to see what it got stuck on. If its things like "log file parallel write" then it might well be an I/O issue. However, it could be t...
test-img

Connor McDonald

Posts

Questions

Blogs

Jobs