鸣谢:http://chwshuang.iteye.com/blog/1578428
查询oracle数据库最近的SQL操作
- select * from v$sql
select * from v$sql
根据时间查询最近的操作
select * from v$sql where LAST_ACTIVE_time between to_date('2012-07-05/16:50:15','yyyy-mm-dd/hh24:mi:ss') and to_date('2012-07-05/17:03:15','yyyy-mm-dd/hh24:mi:ss') and SQL_TEXT LIKE '%ud_zyxk_zysq%'
查询日志文件在数据库主机的物理位置
- select * from v$logfile;
select * from v$logfile;
查询某张表在数据库中最近某个时间点的数据状态的操作
- select * from 表名 as of timestamp to_timestamp('2012-7-5 17:00:10','YYYY-MM-DD HH24:MI:SS')
select * from 表名 as of timestamp to_timestamp('2012-7-5 17:00:10','YYYY-MM-DD HH24:MI:SS')