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

select sql_text，last _ load _ time from v＄SQL order by last _ load _ time desc；

SELECT sql_text，last _ load _ time FROM v＄SQL WHERE last _ load _ time NOT NULL and SQL _ text like ' SELECT % ' ORDER BY last _ load _ time desc。

SELECT sql_text，last _ load _ time FROM v＄SQL WHERE last _ load _ time NOT NULL and SQL _ text like ' update % ' ORDER BY last _ load _ time desc。

SELECT sql_text，last_load_time FROM v＄SQL其中last _ load _ time不为空，last _ load _ time like ' 14-06-09% ' ORDER BY last _ load _ time desc；