Log Miner help
From: Lyall Barbour <lyallbarbour_at_sanfranmail.com>
Date: Tue, 18 Apr 2017 21:31:08 +0200
Message-ID: <trinity-7e49a176-35da-4a74-9bc4-5c2685f13e5a-1492543868017_at_3capp-mailcom-lxa11>
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 18 2017 - 21:31:08 CEST
Date: Tue, 18 Apr 2017 21:31:08 +0200
Message-ID: <trinity-7e49a176-35da-4a74-9bc4-5c2685f13e5a-1492543868017_at_3capp-mailcom-lxa11>
Hello gurus,
Are there any log miner specific gurus out there? i've had a rough month and am currently trying to mine about 5 days of archive logs and the query is taking forever.
1) no supplemental logging on in the past
2) dbms_logmnr_d.build (options => dbms_logmnr_d.store_in_redo_logs)
3) add_logfile (.newfile, then a bunch of addfile)
4) start_logmnr (starttime'04/14', endtime 4/18, DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + DBMS_LOGMNR.CONTINUOUS_MINE )
5) then run the query that's taking about 7 hours so far and not come back to the spool file.
Any ideas to speed it up? Hell, i'm not even sure if my query will get what i want... and that's taken 7 hours so far, yipee!
Lyall Barbour