3

in the last few days our Oracle DB has been generating a large amount of archive log files. How would I find out what DML activity has been causing such a spike in log file generation?

1 Answer 1

1

First check the addm reports and see what sql did the most block changes. Most likely these are the ones you are looking for. An other reason could be that your database setup changed to force_logging and that your load processes now started logging as a result of this change. If you have no diagnostics pack license, you could use logminer to read the archives and generate the undo transactions for what is in the log. This also gives lots of info. You might want to check the archive log history first to find where you find a changed pattern.

4
  • Do you have a good resource for using logminer?
    – Lloyd
    Apr 11, 2011 at 12:20
  • download.oracle.com/docs/cd/E11882_01/appdev.112/e16760/… Start a new logminer session, add the files you want and query the V$LOGMNR_CONTENTS view to actually read the contents. Keep an eye on the alertlog, usefull debugging info appears here.
    – user69489
    Apr 11, 2011 at 14:14
  • Logminer was the trick. That was non-trivial, but powerful.
    – Lloyd
    Apr 13, 2011 at 16:31
  • Yes, it is a good tool, not entirely intuitive .....
    – user69489
    Apr 15, 2011 at 6:25

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .