SQL> select name from v$event_name where name like '%TX%'; NAME ---------------------------------------------------------------- enq: TX - row lock contention enq: TX - allocate ITL entry enq: TX ...
Enqueues are sophisticated locks for managing access to shared resources like tables, rows, jobs, and redo threads. An enqueue can be requested in different levels/mode: null, row share, row exclusiv...
