Hi all,
I was wondering if anyone had experienced a problem with Oracle and latch contention with IFS as since last week we have had hangs in the system due to "latch: cache buffers chains " - By hang I mean
A) users screens endlessly load
B) background jobs never finish.
After speaking to our 3rd party DBA support they have told us this is not a block or locking session, just a wait on accessing the same sector of data however the "wait" never finishes and we just have sessions hanging. A restart of the database server has corrected this 3 times now but this is obviously not ideal. We've raised this with both oracle and IFS but I'm hoping to understand if its a problem for other customers.
The same SQL can be seen running as the contention point, which makes sense however I cant understand why the transaction NEVER finishes. It might be conscience but we also see the explain plan for the SQL statement change before and after the restart of the DB server.
Appreciate this is quite a heavy DBA question and I’ve not given firm examples otherwise this would be pages long, but more a question on if anyone has experienced anything similar?