Oracle中hang session的查询与处理

1. 查询 hang session.
   1. by username
      select a.sid, a.serial#, b.sql_text from v$session a, v$sqlarea b where a.sql_address=b.address and a.username='xx' ;
   2. by provide sid
      select a.sid, a.serial#, b.sql_text from v$session a, v$sqlarea b where a.sql_address=b.address and a.sid='xx' ;
   3. find a blocking session detail
      select a.blocking_session, a.sid, a.serial#, a.wait_class, a.seconds_in_wait, b.sql_text from v$session a, v$sqlarea b where a.blocking_session is not NULL and a.sql_address=b.address order by a.blocking_session;
2. 处理 hang session
   1. alter system kill session 'sid,serial#' ;
   2. ps -ef|grep pid, kill -9 PID