Oracle利用log miner在线日志查询执行的sql

--查看当前归档日志组

SELECT * FROM v$log WHERE status='CURRENT'

select * froM V$LOGFILE ;

--统计某当前归档文件

BEGIN

   dbms_logmnr.add_logfile('D:\data\LOG\REDO02.LOG',dbms_logmnr.new);

END;

--开始统计归档文件

BEGIN

  dbms_logmnr.start_logmnr(options=>dbms_logmnr.dict_from_online_catalog);

  END;

--查询当前归档日志归档日志

SELECT INSTR(SQL_REDO,'data_his'),COUNT(*) FROM V$LOGMNR_CONTENTS  WHERE SQL_REDO IS NOT NULL GROUP BY INSTR(SQL_REDO,'data_his')

SELECT *FROM V$LOGMNR_CONTENTS WHERE SQL_REDO IS NOT NULL;

 

SELECT *

  FROM V$LOGMNR_CONTENTS

 WHERE SQL_REDO IS NOT NULL

   AND TIMESTAMP >= TO_DATE('2019-05-20 22:30:00', 'YYYY-MM-DD HH24:MI:SS')

--结束统计归档文件

BEGIN

   dbms_logmnr.END_LOGMNR;

END;