ALL Oracle Enqueue List
| Enqueue Type | Notes |
| BL | Buffer Cache Management |
| CF | Controlfile Transaction |
| CI | Cross-instance Call Invocation |
| CU | Bind Enqueue |
| DF | Datafile |
| DL | Direct Loader Index Creation |
| DM | Database Mount |
| DR | Distributed Recovery |
| DX | Distributed TX |
| FS | File Set |
| IN | Instance Number |
| IR | Instance Recovery |
| IS | Instance State |
| IV | Library Cache Invalidation |
| JQ | Job Queue |
| KK | Redo Log "Kick" |
| L[A-P] | Library Cache Lock |
| MR | Media Recovery |
| N[A-Z] | Library Cache Pin |
| PF | Password File |
| PI | Parallel Slaves |
| PR | Process Startup |
| PS | Parallel Slave Synchronization |
| Q[A-Z] | Row Cache |
| RT | Redo Thread |
| SC | System Commit Number |
| SM | SMON |
| SQ | Sequence Number Enqueue |
| SR | Synchronized Replication |
| SS | Sort Segment |
| ST | Space Management Transaction |
| SV | Sequence Number Value |
| TA | Transaction Recovery |
| TM | DML 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 |
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26706/viewspace-64580/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
