Oracle Disconnects the deadlock user

--view disk statements that consume the most disk read and write rates Select * from(SelectV.sql_id,v.child_number,v.sql_text,v.elapsed_time,v.cpu_time,v.disk_reads,rank () Over(Order  byV.disk_readsdesc) Elapsed_rank fromV$sql v) awhereElapsed_rank<= Ten; --to view the statement that generated the table lock, you can go to the SID numberSelect *  fromV$lockwhereType='TX'; --view sessions, according to Sid and Serial# fields, to disconnect the sessionSelect *  fromV$sessionwhereSid=147;Select *  fromV$sessionwhereSid=138; --view the machine that generated the deadlockSelectUsername,sid,serial#,lockwait,status,machine,program fromV$sessionwhereSidinch (Selectsession_id fromv$locked_object)--Disconnect the sessionAlterSystemKillSession'138,45'; --to view the SQL statement that generated the deadlockSelectSql_text fromV$sqlwhereHash_valueinch (SelectSql_hash_value fromV$sessionwhereSidinch (Selectsession_id fromV$locked_object))

Oracle Disconnects the deadlock user