Oracle Queue type

This article refers to the official ORACLE11GR2 documentOracle? Database Reference11G Release 2 (11.2)

Queue definition:The Oracle queue has a lock on the serial Access database resource in shared memory. It arises in a single reply or a thing.

Queue Lookup : The Lock_type column in the system database Dictionary view dba_lock_internal and Dba_lock.

cause : The Oracle resource uniquely identifies an object that can be used between different session instances in an instance (local resource) or (global Resource). Each session tries to lock the resource so it generates a queue

Queue name : (Front is short, that is, the database dictionary isolated content, followed by explanation)

? BL, Buffer Cache Management

? BR, Backup/restore

? CF, Controlfile Transaction

? CI, Cross-instance call invocation

? CU, Bind Enqueue

? DF, DataFile

? DL, Direct Loader Index Creation

? DM, Database Mount

? DR, distributed Recovery Process

? DW, Securefiles

? DX, distributed Transaction

? FP, File Object

? FS, File Set

? HW, High-water Lock

? In, Instance number

? IR, Instance Recovery

? is, Instance state

? IV, Library Cache invalidation

? JI, Enqueue used during AJV snapshot refresh

? JQ, Job Queue

? KK, Redo Log "Kick"

? KP, contention in Oracle Data Pump startup and shutdown processes

KO, multiple Object Checkpoint

? L[a-p], Library Cache Lock

? LS, Log Start or Switch

? MM, Mount Definition

? MR, Media Recovery

? N[a-z], Library Cache Pin

? PE, ALTER SYSTEM SET PARAMETER = VALUE

? PF, Password File

? PI, Parallel Slaves

? PR, Process Startup

PS, Parallel Slave synchronization

? Q[a-z], Row Cache

? RO, Object reuse

? RT, Redo Thread

? RW, Row Wait

? SC, System Commit number

? SM, Smon

? SN, Sequence number

? SQ, Sequence number Enqueue

? SR, Synchronized Replication

? SS, Sort Segment

? ST, Space Management Transaction

? SV, Sequence number Value

? TA, Transaction Recovery

? TC, Thread Checkpoint

? TE, Extend Table

? TM, DML Enqueue

? To, temporary Table Object Enqueue

? TS, temporary Segment (also tablespace)

? TT, Temporary Table

? TX, Transaction

? UL, user-defined Locks

? UN, User Name

? US, Undo Segment, serialization

? WL, Being written Redo Log

? XA, Instance Attribute Lock

? XI, Instance registration Lock

There was a document in front of the queue, then did not do too much to explain, so specifically to add a bit

Wait Event: http://blog.csdn.net/jacson_bai/article/details/38323821