解决oracle死锁

《解决oracle死锁》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、一个解决过程，仅供参考，呵呵SQL>connsystem/managerConnected.SQL>SQL>SQL>select*fromv$locked_object;XIDUSNXIDSLOTXIDSQNOBJECT_IDSESSION_ID--------------------------------------------------ORACLE_USERNAMEOS_USER_NAMEPROCESSLOCKED_MODE-----------------------------------------------------------------5

2、47240538618YANJIBSaccount181583547240546718YANJIBSaccount181583SQL>SQL>selectsid,serial#,username,programfromv$sessionwheresid='18';SIDSERIAL#USERNAME--------------------------------------------------PROGRAM------------------------------------------------186548YANJIBSsqlplus@jl_yj(TN

3、SV1-V3)SQL>SQL>altersystemkillsession'18,6548';Systemaltered.SQL>SQL>SQL>selectsid,serial#,username,programfromv$sessionwheresid='18';SIDSERIAL#USERNAME--------------------------------------------------PROGRAM------------------------------------------------186548YANJIBSsqlplus@jl_yj(

4、TNSV1-V3)SQL>SQL>altersystemkillsession'18,6548';Systemaltered.SQL>altersystemkillsession'18,6548';Systemaltered.SQL>selectsid,serial#,username,programfromv$sessionwheresid='18';SIDSERIAL#USERNAME--------------------------------------------------PROGRAM-------------------------------

5、-----------------186548YANJIBSsqlplus@jl_yj(TNSV1-V3)SQL>descv$sessionNameNull?Type-------------------------------------------SADDRRAW(8)SIDNUMBERSERIAL#NUMBERAUDSIDNUMBERPADDRRAW(8)USER#NUMBERUSERNAMEVARCHAR2(30)COMMANDNUMBEROWNERIDNUMBERCOMMANDNUMBEROWNERIDNUMBERTADDRVARCHAR2(16)LO

6、CKWAITVARCHAR2(16)STATUSVARCHAR2(8)SERVERVARCHAR2(9)SCHEMA#NUMBERSCHEMANAMEVARCHAR2(30)OSUSERVARCHAR2(15)PROCESSVARCHAR2(9)MACHINEVARCHAR2(64)TERMINALVARCHAR2(10)PROGRAMVARCHAR2(48)TYPEVARCHAR2(10)SQL_ADDRESSRAW(8)SQL_HASH_VALUENUMBERPREV_SQL_ADDRRAW(8)PREV_HASH_VALUENUMBERMODULEVARC

7、HAR2(48)MODULE_HASHNUMBERACTIONVARCHAR2(32)ACTION_HASHNUMBERCLIENT_INFOVARCHAR2(64)FIXED_TABLE_SEQUENCENUMBERROW_WAIT_OBJ#NUMBERROW_WAIT_FILE#NUMBERROW_WAIT_BLOCK#NUMBERROW_WAIT_ROW#NUMBERLOGON_TIMEDATELAST_CALL_ETNUMBERPDML_ENABLEDVARCHAR2(3)FAILOVER_TYPEVARCHAR2(13)FAILOVER_METHODV

8、ARCHAR2(10)F