Question

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

Answer 1

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 IS 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 IS NOT NULL and sql_text like 'update%' ORDER BY last_load_time DESC;

SELECT sql_text, last_load_time FROM v$sql WHERE last_load_time IS NOT NULL and last_load_time like' 14-06-09%' ORDER BY last_load_time DESC;

Answer 2

在oracle上看的话，只能启用sql trace了，尽量在数据库用户、操作比较少的时候做，否则会混入很多别的用户或程序执行的语句。
简单一点是在应用程序中写sql语句的日志。