使用 logminer,挖掘指定时间点的归档日志进行分析;
根据时间范围查询就好了,比如:select * from a where a.create_date between to_date('20170101','yyyy/mm/dd') and to_date('20170531','yyyy/mm/dd')