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?
migrated from stackoverflow.com Apr 11 '11 at 22:49
This question came from our site for professional and enthusiast programmers.
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.