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.
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.