解决oracle死锁.doc

一个解决过程，仅供参考，呵呵SQL conn system/managerConnected.SQLSQLSQL select * from v$locked_object; XIDUSN XIDSLOT XIDSQN OBJECT_ID SESSION_ID- - - - -ORACLE_USERNAME OS_USER_NAME PROCESS LOCKED_MODE- - - - 5 47 240 5386 18YANJIBS account 18158 3 5 47 240 5467 18YANJIBS account 18158 3SQLSQL select sid, serial#, username, program from v$session where sid = 18; SID SERIAL# USERNAME- - -PROGRAM- 18 6548 YANJIBSsqlplusjl_yj (TNS V1-V3)SQLSQL alter system kill session 18, 6548;System altered.SQLSQLSQL select sid, serial#, username, program from v$session where sid = 18; SID SERIAL# USERNAME- - -PROGRAM- 18 6548 YANJIBSsqlplusjl_yj (TNS V1-V3)SQLSQL alter system kill session 18, 6548;System altered.SQL alter system kill session 18, 6548;System altered.SQL select sid, serial#, username, program from v$session where sid = 18; SID SERIAL# USERNAME- - -PROGRAM- 18 6548 YANJIBSsqlplusjl_yj (TNS V1-V3)SQL desc v$sessionName Null? Type- - -SADDR RAW(8)SID NUMBERSERIAL# NUMBERAUDSID NUMBERPADDR RAW(8)USER# NUMBERUSERNAME VARCHAR2(30)COMMAND NUMBEROWNERID NUMBERCOMMAND NUMBEROWNERID NUMBERTADDR VARCHAR2(16)LOCKWAIT VARCHAR2(16)STATUS VARCHAR2(8)SERVER VARCHAR2(9)SCHEMA# NUMBERSCHEMANAME VARCHAR2(30)OSUSER VARCHAR2(15)PROCESS VARCHAR2(9)MACHINE VARCHAR2(64)TERMINAL VARCHAR2(10)PROGRAM VARCHAR2(48)TYPE VARCHAR2(10)SQL_ADDRESS RAW(8)SQL_HASH_VALUE NUMBERPREV_SQL_ADDR RAW(8)PREV_HASH_VALUE NUMBERMODULE VARCHAR2(48)MODULE_HASH NUMBERACTION VARCHAR2(32)ACTION_HASH NUMBERCLIENT_INFO VARCHAR2(64)FIXED_TABLE_SEQUENCE NUMBERROW_WAIT_OBJ# NUMBERROW_WAIT_FILE# NUMBERROW_WAIT_BLOCK# NUMBERROW_WAIT_ROW# NUMBERLOGON_TIME DATELAST_CALL_ET NUMBERPDML_ENABLED VARCHAR2(3)FAILOVER_TYPE VARCHAR2(13)FAILOVER_METHOD VARCHAR2(10)FAILED_OVER VARCHAR2(3)SQLSQL !sh$ ps -ef|grep sqlplusaccount 14710 28194 0 17:31:55 pts/3 0:00 grep sqlplusaccount 18158 17664 0 16:07:54 pts/2 0:00 sqlplus oracle 18212 24732 0 16:59:36 pts/4 0:00 sqlplus system/manageraccount 23326 24956 0 17:05:43 pts/3 0:00 sqlplus$ exitSQL select process from v$session where sid = 18;PROCESS-18158SQL !sh$ ps -ef|grep 18158account 14712 28196 0 17:33:04 pts/3 0:00 grep 18158account 18158 17664 0 16:07:54 pts/2 0:00 sqlplusaccount 19490 18158 0 16:08:05 - 0:00 oraclectc (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)$ kill 18158$ ps -e