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

  • From: <Jan-Hendrik.Boll@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 10 Nov 2009 15:09:38 +0100

One of theese files will be created each time you logon as "/as sysdba "
Could be rman or other stuff.
 
Metalink,

How to Audit Connect AS SYSDBA Using Oracle Server (Doc ID 103964.1):


"The administrative user connections are always audited regardless of
the init.ora parameter audit_trail."

 
Regards,
Jan

________________________________

Von: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] Im Auftrag von
anelson77388@xxxxxxxxx
Gesendet: Dienstag, 10. November 2009 14:54
An: Job Miller
Cc: oracle-l@xxxxxxxxxxxxx
Betreff: Re: Re: About 1.8 million log files in $ORACLE_HOME/rdbms/audit


SQL> select * from v$diag_info;

INST_ID NAME
----------
----------------------------------------------------------------
VALUE
------------------------------------------------------------------------
--------
1 Diag Enabled
TRUE

1 ADR Base
/d20/oracle/product/mbasdb/11.1.0/admin/dest

1 ADR Home
/d20/oracle/product/mbasdb/11.1.0/admin/dest/diag/rdbms/mbas/mbas


INST_ID NAME
----------
----------------------------------------------------------------
VALUE
------------------------------------------------------------------------
--------
1 Diag Trace
/d20/oracle/product/mbasdb/11.1.0/admin/dest/diag/rdbms/mbas/mbas/trace

1 Diag Alert
/d20/oracle/product/mbasdb/11.1.0/admin/dest/diag/rdbms/mbas/mbas/alert

1 Diag Incident
/d20/oracle/product/mbasdb/11.1.0/admin/dest/diag/rdbms/mbas/mbas/incide
nt


INST_ID NAME
----------
----------------------------------------------------------------
VALUE
------------------------------------------------------------------------
--------
1 Diag Cdump
/d20/oracle/product/mbasdb/11.1.0/admin/dest/diag/rdbms/mbas/mbas/cdump

1 Health Monitor
/d20/oracle/product/mbasdb/11.1.0/admin/dest/diag/rdbms/mbas/mbas/hm

1 Default Trace File
/d20/oracle/product/mbasdb/11.1.0/admin/dest/diag/rdbms/mbas/mbas/trace/
mbas_ora
_23961.trc

INST_ID NAME
----------
----------------------------------------------------------------
VALUE
------------------------------------------------------------------------
--------

1 Active Problem Count
8

1 Active Incident Count
81


11 rows selected.

On Nov 9, 2009 11:51am, Job Miller <jobmiller@xxxxxxxxx> wrote:
> Are these ADR files?
> 
> 
> 
> that path doesn't fit the ADR structure.
> 
> 
> 
> what does select * from v$diag_info show?
> 
> 
> 
> ADR should be:
> 
> 
> 
> $ORACLE_BASE/diag/product_type/product_id/instance_id

Other related posts:

  • » AW: Re: About 1.8 million log files in $ORACLE_HOME/rdbms/audit - Jan-Hendrik.Boll