Q
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

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close