oracle_locking_latches_mutexes

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
oracle_locking_latches_mutexes [2020/10/19 07:30] – 86.49.253.137oracle_locking_latches_mutexes [2021/01/07 18:48] (current) – [Enqueues] andonovj
Line 396: Line 396:
  
 =====Enqueues===== =====Enqueues=====
 +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.
 +  * TM: Table modification (or locking a referenced table when the foreign key is not indexed)
 +  * UL: Lock used by user applications, a lock is requested by DBMS_LOCK.REQUEST
 +  * CF: Control file: actions accessing the control file, like: log switch, redo archiving, and backup
 +  * ST: Space Transaction: dictionary-managed tablespaces within extent allocations and releases
 +  * TT: Temporary tablespace: parallel tablespace operations
 +  * CI: Cross-instance: data accessed from multiple instances (db link)
 +  * HV: Parallel direct-path insert
  • oracle_locking_latches_mutexes.1603092617.txt.gz
  • Last modified: 2020/10/19 07:30
  • by 86.49.253.137