Re: Oracle 10g, Trace File (.trc)

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Thu, 15 Oct 2009 07:48:07 -0700 (PDT)
Message-ID: <fde03043-e7f5-479a-bce9-433a58f0d3ad_at_l13g2000yqb.googlegroups.com>

On Oct 15, 9:57 am, "Fabrice" <emouc..._at_spaminfonietest.fr> wrote:

snip

> Hello
>
> I have just installed Oracle 10g Enterprise under Windows2003.
> Oracle create many .trc file to say "nothing". I don't know how to stop
> that.
>
> How to tell to Oracle to stop create TRC file or just during a crash.
>
> Thanks for your help.
> fabrice
>
> --- informations
>
> trace_enabled  is "false"
> show parameter trace;
>
> NAME                                 TYPE        VALUE
> ------------------------------------ ----------- -----------------------------
> log_archive_trace                    integer     0
> sql_trace                            boolean     FALSE
> trace_enabled                        boolean     FALSE
> tracefile_identifier                 string
>
> For example a trc file when I start my database (in bdump)
>
> Dump file f:\oracle\product\10.2.0\admin\oresint\bdump\oresint_lgwr_2804.trc
> Thu Oct 15 15:34:37 2009
> ORACLE V10.2.0.1.0 - Production vsnsta=0
> vsnsql=14 vsnxtr=3
> Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
> With the Partitioning, OLAP and Data Mining options
> Windows Server 2003 Version V5.2 Service Pack 2
> CPU                 : 2 - type 586, 1 Physical Cores
> Process Affinity    : 0x00000000
> Memory (Avail/Total): Ph:1531M/2045M, Ph+PgF:3096M/3944M, VA:1300M/2047M
> Instance name: oresint
>
> Redo thread mounted by this instance: 1
>
> Oracle process number: 6
>
> Windows thread id: 2804, image: ORACLE.EXE (LGWR)
>
> *** SERVICE NAME:() 2009-10-15 15:34:37.828
> *** SESSION ID:(166.1) 2009-10-15 15:34:37.828
> Maximum redo generation record size = 156160 bytes
> Maximum redo generation change vector size = 150672 bytes

Ahh ... well trying to control when and how oracle creates "normal" trace files is kind of like trying to control when and how your wife feels free to give you suggestions.

It doesn't work that way.

Oracle will create normal trace files how and when it feels like it ... what you have to do is monitor the trace files and cleanup ( delete ) the trace files you don't want.

Most of us have scripts setup for our environments to take care of the monitoring and cleanup. Received on Thu Oct 15 2009 - 09:48:07 CDT