Database Administration (MOSC)

MOSC Banner

How should a background process behave if it encounters an i/o problem?

edited Apr 5, 2012 12:36AM in Database Administration (MOSC) 3 commentsAnswered
My customer's 10.2.0.4 database crashed last week. On examination, it became clear that there were some i/o issues, and the MMNL process had tried, and failed, to access a file. It was holding an enqueue at the time. It seemed to hang for around 4 hours until another process, which wanted the enqueue which MMNL was holding, killed MMNL, thus bringing the instance down. I have seen notes which explain that a process, if it has to wait too long (whatever that means) for a row cache enqueue lock, may kill the holding (blocking) process - and that this behaviour

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