欢迎来到天天文库
浏览记录
ID:38376737
大小:30.00 KB
页数:4页
时间:2019-06-11
《解决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
此文档下载收益归作者所有