select distinct bb.STATUS,
bb.USERNAME,
bb.sid,
bb.SERIAL#,
bb.last_call_et runtime,
bb.PROGRAM,
aa.SQL_ID,
aa.sql_text
from v$sql aa, v$session bb
where aa.sql_id = bb.SQL_ID
and bb.status = 'ACTIVE'
and bb.username is not null
order by last_call_et desc;
oracle 查看正在执行的语句,执行时间
最新推荐文章于 2024-06-24 17:29:32 发布