Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

migrated from stackoverflow.com Apr 11 '11 at 22:49

This question came from our site for professional and enthusiast programmers.

1 Answer 1

up vote 0 down vote accepted

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.

share|improve this answer
    
Do you have a good resource for using logminer? –  Lloyd Apr 11 '11 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. –  ik_zelf Apr 11 '11 at 14:14
    
Logminer was the trick. That was non-trivial, but powerful. –  Lloyd Apr 13 '11 at 16:31
    
Yes, it is a good tool, not entirely intuitive ..... –  ik_zelf Apr 15 '11 at 6:25

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.