Problem solve
Get help with specific problems with your technologies, process and projects.
Buffer deadlock in statspack report
Why do we have a "buffer deadlock"? I see this deadlock in the statspack report for Oracle 10.0.1 (Solaris system) associated with DBSNMP schema.
Why do we have a "buffer deadlock"? I see this deadlock in the statspack report for Oracle 10.0.1 (Solaris system) associated with DBSNMP schema. Thanks!
From the Oracle Reference manual:
buffer deadlock: Oracle does not really wait on this event; the foreground only yields the CPU. Thus, the chances of catching this event are very low. This is not an application-induced deadlock, but an assumed deadlock by the cache layer. The cache layer cannot get a buffer in a certain mode within a certain amount of time.
Wait Time: 0 seconds. The foreground process only yields the CPU and will usually be placed at the end of the CPU run queue.
Dig Deeper on Oracle database performance problems and tuning
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments