RE: Those Pesky Little Audit Files (ora_99999.aud)

[Orr, Steve]

Title: RE: Those Pesky Little Audit Files (ora_99999.aud)

that calls for a super-duper-pooper-scooper.  :-)

-----Original Message-----
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 27, 2002 1:09 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Those Pesky Little Audit Files (ora_99999.aud)

Or you might have to do the cleanup sooner if you have 9202 on AIX 5.1 and you have external tables and you run into that (yet unknown) pmon memory leak (where it supposedly corrupts first 80 bytes of memory). When the instance finally crashed, among 540 trace and trw files, one tracefile was 1.3GB (no it is not a type) in size.

Raj
______________________________________________________
Rajendra Jamadagni              MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!

-----Original Message-----
From: Orr, Steve [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 27, 2002 1:10 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Those Pesky Little Audit Files (ora_99999.aud)

Yupp, I do the same thing. I figure if there's a problem documented somewhere in those files and I haven't responded to them in 30-60 days then its too old to worry about anyway. Sometimes OWS wants an alert log which goes back to the beginning of time but I just tell 'em to get real. I just up'd the listerner log renaming routine to run on a daily basis because it was too big too view. Now the average size of the listener.julianday file is 20-50MB. The process of cleaning up oracle log and trace files is like a "pooper-scooper" at the end of the rodeo parade.

Steve Orr
Bozeman, Montana