Common Trouble Solution--解决锁…

解决锁表
 1.以sys 用户登入查询哪些session 被锁
sql>selectt2.username,t2.sid,t2.serial#,t2.logon_time
    fromv$locked_object t1,v$session t2
    wheret1.session_id=t2.sid order by t2.logon_time;

2.根据sid查询该会话的具体sql语句
sql>select sql_text
    fromv$session a ,v$sqltext_with_newlines b
    where
    DECODE(a.sql_hash_value,0 ,prev_hash_value,sql_hash_value)=b.hash_value  
    anda.sid=&sid order by piece;
   


3.可以记录 《2》中查询的sql语句，然后kill 该会话。

  sql>alter system kill session'512,2186';