SQL_REDO www.2cto.com
----------------------------------------------------------------------------------------
SQL_UNDO
----------------------------------------------------------------------------------------
create table logmnr_test (id number,name varchar2(20));
select username,session_info from v$logmnr_contents
where seg_name='LOGMNR_TEST' and
seg_owner='HR' and
seg_type_name='TABLE'
2)执行容量分析
如分析表产生DML的频数和频率
[sql]
select operation,timestamp,count(*) total from v$logmnr_contents
where seg_name='LOGMNR_TEST' and
seg_owner='HR' and
seg_type_name='TABLE'
group by operation,timestamp;
OPERATION TIMESTAMP TOTAL
-------------------------------- ------------------- ----------
DDL 2012/09/09 08:20:47 1
3)寻找DDL命令的细节
例如，使用logminer，可以找出删除表的具体时间和scn，便于media recovery。
[sql]
select seg_name,operation,scn,timestamp,count(*)
from v$logmnr_contents www.2cto.com
where operation='DELETE'
group by seg_name,operation,scn,timestamp
order by scn;
5 关闭logminer
如果需要进一步的分析，可将v$logmnr_contents内容保存下来
create table logmnr_contents as select * from v$logmnr_contents;
然后，执行关闭：
exec dbms_logmnr.end_logmnr;
附图：
