Re: Re: About 1.8 million log files in $ORACLE_HOME/rdbms/audit
- From: anelson77388@xxxxxxxxx
- To: Job Miller <jobmiller@xxxxxxxxx>
- Date: Tue, 10 Nov 2009 13:54:22 +0000
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@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: