Re: Log rotation and management

Hi Jared,

>> As I now have several eBiz apps systems to care for, I am wallowing
>> in a sea of log files.

EBS will produce a ton of log files, and all over the place as noted. The Apache logs are the easiest. Some are automatically purged - Concurrent manager logs for e.g. - via the Purge Concurrent program (need to make sure it is configured to purge the right amount). You will also have to watch out for files created in the /tmp and /usr/tmp directories (PL/SQL and Webapps traces) that are not automatically purged. Cron based purges work for these.

The *real* kicker though is the Gunk that collects *inside* the database. Depending on Debug, Audit and other flags (very configurable, and buried in a variety of places, turned on by patches and other profile settings, etc.), you will slowly and gradually choke the system with extraneous rows in tables that you never heard about. Workflow Purging and Attachments (FND_LOBS) are two such cases - this needs to be carefully configured and closely watched. You will need to work with (pursue is a better word) the "Functional" and "Technical" folks to understand what they are turning on (or have turned on at some point) and determine what needs to be purged (not everything has an inbuilt purge). The version and patches complicates this picture even further.... I remember there was a paper or two on this at OAUG, but I don't have that with me right now :(

I would suggest that you preserve and check row counts for tables (snapshots of DBA_TABLES for Apps module tables, compare NUM_ROWS and BLOCKS) so you can track what is growing.

Best of Luck!

-- 
John Kanagaraj <><
DB Soft Inc
http://www.linkedin.com/in/johnkanagaraj
http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!)
** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **
--
http://www.freelists.org/webpage/oracle-l