有时需要根据操作系统编号查找正在执行的sql语句:
select
sess.username,
sql1.SQL_TEXT
from v$session sess,
v$sqltext sql1,
v$process pro
where
sess.SQL_ADDRESS=sql1.ADDRESS
and
pro.ADDR=sess.PADDR and pro.SPID='&spid'
order by sql1.PIECE;
http://www.oracle-wiki.net/startsql
此网址中有很多好玩的sql
select
sess.username,
sql1.SQL_TEXT
from v$session sess,
v$sqltext sql1,
v$process pro
where
sess.SQL_ADDRESS=sql1.ADDRESS
and
pro.ADDR=sess.PADDR and pro.SPID='&spid'
order by sql1.PIECE;
http://www.oracle-wiki.net/startsql
此网址中有很多好玩的sql
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29135257/viewspace-2132848/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29135257/viewspace-2132848/