Re: About 1.8 million log files in $ORACLE_HOME/rdbms/audit

From: <Mayen.Shah_at_lazard.com>
Date: Wed, 4 Nov 2009 09:53:30 -0500
Message-ID: <OFC4185BEA.E945A0D5-ON85257664.00519279-85257664.0051CDB0_at_lazard.com>

Hi Allan,

Do you have audit_trail set to OS?
What is the value for audit_sys_operations ?

• Mayen

anelson77388_at_gmail.com
Sent by: oracle-l-bounce_at_freelists.org Nov 04 2009 09:37 AM
Please respond to
anelson77388_at_gmail.com

To
"oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
cc

Subject
About 1.8 million log files in $ORACLE_HOME/rdbms/audit

Hi Listers,

We recently upgraded from 10.1.0.5 to 11.1.0.7 on HP-UX 11.31. We now have about 1.8 million log files generated in $ORACLE_HOME/rdbms/audit that have stuff like this in them:
Audit file
/d20/oracle/product/mbasdb/11.1.0/rdbms/audit/mbas_ora_20316_14.aud Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /d20/oracle/product/mbasdb/11.1.0 System name: HP-UX
Node name: mihp2

Release: B.11.31
Version: U
Machine: ia64

Instance name: mbas
Redo thread mounted by this instance: 1
Oracle process number: 369
Unix process pid: 20316, image: oracle_at_mihp2

Sat Oct 3 22:48:40 2009
LENGTH: "184"
SESSIONID:[9] "101968946" ENTRYID:[1] "1" ACTION:[3] "102" RETURNCODE:[1]
"0" LO

GOFF$PREAD:[1] "0" LOGOFF$LREAD:[3] "388" LOGOFF$LWRITE:[1] "4" LOGOFF$DEAD:[1]
"0" SESSIONCPU:[1] "4"
Any idea how to control this?

Allan

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Nov 04 2009 - 08:53:30 CST