Oracle数据库中英文session,oracle session常用话语

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