select q.FIRST_LOAD_TIME,q.sql_text
from v$session s, v$sqlarea q
where s.user# = q.parsing_user_id and s.status='ACTIVE'
and s.username='用户名'
order by q.FIRST_LOAD_TIME DESC;
Oracle监视sql执行
最新推荐文章于 2023-07-13 16:44:27 发布
select q.FIRST_LOAD_TIME,q.sql_text
from v$session s, v$sqlarea q
where s.user# = q.parsing_user_id and s.status='ACTIVE'
and s.username='用户名'
order by q.FIRST_LOAD_TIME DESC;