ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

来源:互联网 发布:淘宝男装最出名的店 编辑:程序博客网 时间:2024/05/18 05:37

SELECT t2.username,  t2.sid,  t2.serial#,  t2.logon_timeFROM v$locked_object t1,  v$session t2WHERE t1.session_id=t2.sidORDER BY t2.logon_time;SELECT sql_textFROM v$session a,  v$sqltext_with_newlines bWHERE DECODE(a.sql_hash_value, 0, prev_hash_value, sql_hash_value)=b.hash_valueAND a.sid=&pid                                                     ORDER BY piece;alter system kill session '22,467';


原创粉丝点击