oracle session常用语句

zxiipizhnk

　　--查阻塞的会话：
--查询语句：
Select osuser,machine,program,Module,sid,serial#,event,t2.logon_time
from v$locked_object t1,v$session t2
where t1.session_id=t2.sid order by t2.logon_time
　　--提取SQL语句：
--根据sid用如下语句提取：
SELECT /*+ PUSH_SUBQ */
Sql_Text, Sharable_Mem, Persistent_Mem, Runtime_Mem,First_Load_Time, SYSDATE Start_Time
FROM V$sqlarea
WHERE Address = (SELECT Sql_Address
FROM V$session
Where Sid = 131);
　　--a.组装杀死锁的语句（dba权限）：
select 'alter system kill session '||chr(39)||t2.sid||','||t2.serial#||chr(39)||';'
from v$locked_object t1,v$session t2
where t1.session_id=t2.sid order by t2.logon_time