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

From: <Jan-Hendrik.Boll_at_dataport.de>
Date: Tue, 10 Nov 2009 15:09:38 +0100
Message-ID: <0FCF70745FD57F4F8259112EC5E800A5019655D6_at_WSCXPR18.fhhnet.stadt.hamburg.de>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] Im Auftrag von anelson77388_at_gmail.com
Gesendet: Dienstag, 10. November 2009 14:54 An: Job Miller
Cc: oracle-l_at_freelists.org
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_at_yahoo.com> 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

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

Received on Tue Nov 10 2009 - 08:09:38 CST