Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Omar.

Asked: June 23, 2020 - 8:02 am UTC

Last updated: June 26, 2020 - 4:19 am UTC

Version: 11g

Viewed 1000+ times

You Asked

can i start logminer once across one connection, reuse it in realtime. meaning that the V$LOGMNR_CONTENTS view gets updated in realtime without having to end logminer session and build it again?
Thank you

and Connor said...

Not real time, but you can do DBMS_LOGMNR.ADD_LOGFILE whenever you want in a session, even if you have already started log miner, and you do not have to do an END.

ie, you can do:

dbms_logmnr.add_logfile
dbms_logmnr.add_logfile
dbms_logmnr.add_logfile
dbms_logmnr.start_logmnr

and query V$LOGMNR_CONTENTS and then do

dbms_logmnr.add_logfile
dbms_logmnr.add_logfile

without needing to run dbms_logmnr.end_logmnr

You might see a "CONTINUOUS_MINE" option in the docs which automatically add log files. I'd recommend against that because it is de-supported in later releases.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

follow up on the logmimer question

Omar, June 24, 2020 - 1:40 pm UTC

is it possible to start the logminer with endtime option using future date and could u please elaborate on which version does the de-support of the 'CONTINUOUS_MINE' option start
Connor McDonald
June 26, 2020 - 4:19 am UTC

12c deprecated.
19c desupported.

start_time / end_time are optional - and thus you should be able to mine all logfiles that you have added via "add_logfile"
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Utilities

All of the database utilities are explained in the Utilities guide.