When a process spawn is aborted while the process spawning background is in the middle of spawning, the current session must wait until the pid of the new process is filled in. Once the pid is filled in, then the process spawn can be actually aborted.
A session waits for a checkpoint to complete. This could happen, for example, during a close database or a local checkpoint.
This event occurs only if the instance is mounted in shared mode (Oracle Real Application Cluster). During the read of the buffer, the contents changed. This means that either: The version number, dba, or the incarnation and sequence number stored in the block no longer match The checksum on the block does not match the…
The session waits on the buffer hash chain latch. Primarily used in the dump routines. The virtual address in the SGA where this latch is located. Use the following statement to find the name of this latch: select * from v$latch a, v$latchname b where addr = latch addr and a.latch# = b.latch#; chain# The…
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…
Processes enter “wait for broadcast mesg recovery queue transition” when cleaning up a publisher channel handle to a RELIABLE broadcast channel. The broadcasted message is in the recovery queue of another channel handle (for example, ch2). Process enters this wait, if the message is yet to be removed from the recovery queue of the ch2…
Used to track the time (in centiseconds) that ARCn background processes spend blocked waiting for network write operations to complete.
A session has issued a statement ALTER SYSTEM SET DISPATCHER = string and is waiting for the dispatchers to get started. Wait Time: The session will wait 1 / 100 of a second and verify if the new dispatchers have started, else the session will wait again
The Buffer cache is implemented as a chain of blocks linked together under a hash value known as cache buffer chains (CBC). When a buffer is requested the hash value of the chain where the buffer is, will be calculated and then that chain is scanned by walking the chain until the buffer is found.…
This article is part of Oracle Performance Tuning Series and is created to describe Oracle’s locking mechanism. A lock is a resource that you need to hold to get access to the resource. Oracle has two kind of locks: enqueues and latches, we would now focus on these locking mechanism individually. Enqueues Enqueues are sophisticated…
Oracle Database Internal Mechanism 