Question

查看oracle数据库最近执行了哪些sql语句

Answer 1

SELECT b.sql_text, --content of SQL
a.machine, --which machine run this code
a.username, a.module, -- the method to run this SQL
c.sofar / totalwork * 100, --conplete percent
c.elapsed_seconds, --run time
c.time_remaining --remain to run time
FROM v$session a, v$sqlarea b, v$session_longops c
WHERE a.sql_hash_value = b.hash_value(+) AND a.SID = c.SID(+)
AND a.serial# = c.serial#(+)
--AND a.sid=139

Answer 2

select * from V$SQL s order by s.LAST_ACTIVE_TIME desc

Answer 3

alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS';
select SQL_TEXT,LAST_ACTIVE_TIME from v$sql where rownum < 10 order by LAST_ACTIVE_TIME;