Client or User Enqueues

TM: DML enqueue

TX: Transaction enqueue

UL: User supplied

Managed or System Enqueues

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 Execution Process 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

TS: Temporary Segment (also TableSpace)

TT: Temporary Table

UN: User Name

US: Undo Segment, Serialization

WL: Being Written Redo Log

XA: Instance Attribute Lock

XI: Instance Registration Lock

Note: The names of enqueues and their definitions may change from release to release.

ITPub博客

ORACLE 中的Enqueue 种类