使用log miner 分析oracle日志

zhltom

SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';　　

　　
Session altered.
　　
SQL> select username,scn,timestamp,sql_redo from v$logmnr_contents where seg_name='T1';
　　
USERNAME                              SCN TIMESTAMP
　　
------------------------------ ---------- -------------------
　　
SQL_REDO
　　
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
　　
delete from "SCOTT"."T1" where "EMPNO" = '7782' and "ENAME" = 'CLARK' and "JOB" = 'MANAGER' and "MGR" = '7839' and "HIREDATE" = TO_DATE('1981-06-09 00:00:00', 'yyyy-mm-dd hh24:mi:ss') and "SAL" = '245
　　
0' and "COMM" IS NULL and "DEPTNO" = '10' and ROWID = 'AAAVbSAAFAAAACXABi';
　　

　　
SYS                               1494545 2015-06-28 04:24:44
　　
delete from "SCOTT"."T1" where "EMPNO" = '7839' and "ENAME" = 'KING' and "JOB" = 'PRESIDENT' and "MGR" IS NULL and "HIREDATE" = TO_DATE('1981-11-17 00:00:00', 'yyyy-mm-dd hh24:mi:ss') and "SAL" = '500
　　
0' and "COMM" IS NULL and "DEPTNO" = '10' and ROWID = 'AAAVbSAAFAAAACXABj';
　　

　　
SYS                               1494545 2015-06-28 04:24:44
　　
delete from "SCOTT"."T1" where "EMPNO" = '7844' and "ENAME" = 'TURNER' and "JOB" = 'SALESMAN' and "MGR" = '7698' and "HIREDATE" = TO_DATE('1981-09-08 00:00:00', 'yyyy-mm-dd hh24:mi:ss') and "SAL" = '1
　　
。。。。。