Oracle DBA ++

Automatic Transaction Rollback - A new feature in Oracle 23ai

enq: TX – Row Lock Contention Handled in Oracle 23ai

Rupesh Ghubade September 21, 2025

What is "enq: TX - row lock contention" ? A row is locked when one session attempts to modify the data in t…

enq: TX - allocate ITL entry

Rupesh Ghubade September 16, 2025

What is ITL (Interested Transaction List) ? ITL(Interested Transaction List) is a table which is stored in a block hea…