Oracle-L: RE: Those Pesky Little Audit Files (ora

From: Orr, Steve <sorr_at_rightnow.com>
Date: Fri, 27 Dec 2002 14:43:55 -0800
Message-ID: <F001.00523711.20021227144355@fatcity.com>

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

-----Original Message-----
Sent: Friday, December 27, 2002 1:09 PM
To: Multiple recipients of list ORACLE-L

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-----
Sent: Friday, December 27, 2002 1:10 PM To: Multiple recipients of list ORACLE-L

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Orr, Steve
INET: sorr_at_rightnow.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Dec 27 2002 - 16:43:55 CST

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