oracle session常用语句的简介与内容

--查阻塞的会话：
--查询语句：
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