Differences

This shows you the differences between two versions of the page.

--- oracle_locking_latches_mutexes [2021/01/07 18:45] – [Enqueues] andonovj
+++ oracle_locking_latches_mutexes [2021/01/07 18:48] (current) – [Enqueues] andonovj
@@ Line 398: / Line 398: @@
 Enqueues are your standard locks and they come in several tyes:
-  * TX Transaction lock: mode 6: data modification, mode 4: setting tablespace to read only, foreign key enforcement, unique index key enforcement, ITL space waits, and more.
+  * TX: Transaction lock:
-  * TM Table modification (or locking a referenced table when the foreign key is not indexed)
+  *   * mode 6: data modification,
-  * UL Lock used by user applications, a lock is requested by DBMS_LOCK.REQUEST
+  *   * mode 4: setting tablespace to read only, foreign key enforcement, unique index key enforcement, ITL space waits, and more.
-  * CF Control file: actions accessing the control file, like: log switch, redo archiving, and backup
+  * TM: Table modification (or locking a referenced table when the foreign key is not indexed)
-  * ST Space Transaction: dictionary-managed tablespaces within extent allocations and releases
+  * UL: Lock used by user applications, a lock is requested by DBMS_LOCK.REQUEST
-  * TT Temporary tablespace: parallel tablespace operations
+  * CF: Control file: actions accessing the control file, like: log switch, redo archiving, and backup
-  * CI Cross-instance: data accessed from multiple instances (db link)
+  * ST: Space Transaction: dictionary-managed tablespaces within extent allocations and releases
-  * HV Parallel direct-path insert
+  * TT: Temporary tablespace: parallel tablespace operations
+  * CI: Cross-instance: data accessed from multiple instances (db link)
+  * HV: Parallel direct-path insert