Re: Re: About 1.8 million log files in $ORACLE_HOME/rdbms/audit
Date: Tue, 10 Nov 2009 13:54:22 +0000
Message-ID: <001636c92bb7c07961047804a517_at_google.com>
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/incident
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-lReceived on Tue Nov 10 2009 - 07:54:22 CST