HOW TO FIND ALL SESSIONS HOLDING A TABLE LOCK
Query to check table lock in Oracle database.
ORA-02049: TIMEOUT: DISTRIBUTED TRANSACTION WAITING FOR LOCK
oerr ora 02049 - The number of seconds specified in the distributed_lock_timeout initialization parameter were exceeded while waiting for a lock or for a begin transaction hash collision to end.
HOW TO MATCH OS PROCESS WITH ORACLE SESSION
What is a particular OS Oracle process (PID) executing in an Oracle database?
WHAT IS DEAD CONNECTION DETECTION (DCD) IN THE ORACLE DATABASE
How to clean up all abnormally terminated sessions between client and database server?
HOW TO IDENTIFY BLOCKED AND BLOCKING SESSIONS IN ORACLE DATABASE
A query to identify blocked and blocking sessions in an Oracle Database.