Oracle Database
A transaction wait often reflects another session's uncommitted work, but TX waits have several causes. Match the event with blocker and object evidence.
Sessions, Locks & Transactions2 min read
Read article : Diagnose enq: TX - row lock contention in context
Oracle Database
An INACTIVE session can retain an open transaction while its application waits for user input or abandons a request.
Sessions, Locks & Transactions1 min read
Read article : Find idle sessions that still hold transactions
Oracle Database
A transaction can hold locks and generate undo for much longer than the visible user request. Collect its age and scale before planning a stop.
Sessions, Locks & Transactions2 min read
Read article : Assess a long-running transaction before intervention
Oracle Database
A cancelled operation may be reported after a user action, driver timeout or application cancellation. The cancellation message does not explain why execution took too long.
Sessions, Locks & Transactions2 min read
Read article : ORA-01013: distinguish user cancellation from the cause of slowness
Oracle Database
A session-killed error can follow an administrator action, resource enforcement or another managed operation. Preserve the time and account context.
Sessions, Locks & Transactions1 min read
Read article : ORA-00028: investigate why a session was terminated
Oracle Database
Host CPU or a trace file may name a process rather than a database session. Join the session and process views before escalating.
Sessions, Locks & Transactions2 min read
Read article : Map an Oracle session to its server process
Oracle Database
A session ceiling can reject new work even while existing sessions appear idle. Measure usage and explain which client groups own it.
Sessions, Locks & Transactions1 min read
Read article : ORA-00018: investigate the maximum session limit
Oracle Database
New logins can fail when the instance cannot allocate another process slot. Existing connections may still let an authorized DBA collect evidence.
Sessions, Locks & Transactions1 min read
Read article : ORA-00020: investigate Oracle process exhaustion
Oracle Database
One account may be unable to open another session while the database has capacity. Inspect its assigned profile and session limit.
Sessions, Locks & Transactions2 min read
Read article : ORA-02391: check a user's concurrent-session profile limit
Oracle Database
A server-enforced idle limit can leave the client holding a connection that fails when reused. Check the account profile and pool lifecycle.
Sessions, Locks & Transactions2 min read
Read article : ORA-02396: handle an idle-time limit in a connection pool
Oracle Database
An event name can remain visible when a session is no longer waiting. Interpret the event together with its state and wait class.
Sessions, Locks & Transactions2 min read
Read article : Read Oracle session wait state without confusing past and current waits
Oracle Database
A local session view can identify a blocker on another RAC instance without showing that session's full details. Preserve instance identity in every lookup.
Sessions, Locks & Transactions2 min read
Read article : Find blocking sessions across RAC instances