Transaction locks in Oracle (locked tables and locked sessions)

Transaction locks in Oracle (locked tables and locked sessions) Today I learned another trick to view the transaction locks caused by abnormal session exits in Oracle Database: 1. view the locked table SELECT B. owner, B. object_name,. session_id,. locked_mode FROM v $ locked_object a, dba_objects B WHERE B. object_id =. object_id; 2. view the locked Session SELECT B. username, B. sid, B. serial #, logon_time FROM v $ locked_object a, v $ session B WHERE. session_id = B. sid order by B. logon_time; 3. if you want to disconnect a session, run Alter system kill session 'sid, serial # 'www.2cto.com