本文參照oracle11gr2官方文檔《Oracle? Database Reference11g Release 2 (11.2)》
隊列定義：oracle隊列存在共享內存中串行訪問數據庫資源的鎖。它產生於一次回話或者一個事物。
隊列查找：在系統數據庫詞典視圖 DBA_LOCK_INTERNAL和DBA_LOCK的Lock_type那一列。
產生原因：oracle資源唯一地標識一個對象,可以被不同的會話實例之間在一個實例(本地資源)或(全球資源)。每個會話試圖鎖定資源所以就會產生隊列
隊列名稱：(前面是簡稱，即數據庫詞典查出的內容，後面是解釋)
?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
前面有一篇文檔用到了隊列，當時沒做過多得解釋，所以專門補充了一下
等待事件：http://blog.csdn.net/jacson_bai/article/details/38323821
