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

From: <anelson77388_at_gmail.com>
Date: Wed, 04 Nov 2009 15:28:53 +0000
Message-ID: <000e0cd23ba0ac56c804778d448b_at_google.com>



audit_trail is DB and audit_sys_operations is FALSE.

Thanks
Allan
On Nov 4, 2009 8:53am, Mayen.Shah_at_lazard.com wrote:

> 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 - 09:28:53 CST

Original text of this message