Oracle查询服务器执行语句

最新推荐文章于 2022-06-16 16:30:06 发布

Eossoft-2020

最新推荐文章于 2022-06-16 16:30:06 发布

阅读量328

点赞数

本文链接：https://blog.csdn.net/xiaoqiaoluanwu/article/details/48733695

版权

-- 查看已经执行过的SQL语句
select username,osuser,process,program,machine,b.SQL_TEXT,b.FIRST_LOAD_TIME,b.SQL_FULLTEXT
from v$sqlarea b
left join v$session a
on a.sql_address = b.address
where b.FIRST_LOAD_TIME between '2013-08-08/10:36:00' and
'2013-08-08/10:40:00' order by b.FIRST_LOAD_TIME

-- 查看正在执行的SQL语句
select a.username,osuser,process,program,machine, a.sid,b.SQL_TEXT, b.SQL_FULLTEXT
from v$session a, v$sqlarea b
where a.sql_address = b.address