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

From: ~Jeff~ <jifjif_at_gmail.com>
Date: Wed, 11 Nov 2009 07:37:42 +1300
Message-ID: <363634910911101037n6e0ca49fuf5e1762b0448f978_at_mail.gmail.com>

we did also run into the issues described in #302801.1, tho we had "only" 10s of thousands of files in $OH/rdbms/log (9i-10g, HP-UX, no async). Found that note by searching ML for the contents of the file - perhaps that'd work for you too ?

Funny thing with #302801.1 is that it puts files there despite the *_dump_dest parameters being defined.

2009/11/11 <anelson77388_at_gmail.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-l

Received on Tue Nov 10 2009 - 12:37:42 CST