Re: Oracle 10g, Trace File (.trc)
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Thu, 15 Oct 2009 09:06:00 -0700 (PDT)
Message-ID: <57c8abd8-a312-468d-8758-baea048cefc1_at_o41g2000yqb.googlegroups.com>
On Oct 15, 10:48 am, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
> 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.- Hide quoted text -
>
> - Show quoted text -
Date: Thu, 15 Oct 2009 09:06:00 -0700 (PDT)
Message-ID: <57c8abd8-a312-468d-8758-baea048cefc1_at_o41g2000yqb.googlegroups.com>
On Oct 15, 10:48 am, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
> 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.- Hide quoted text -
>
> - Show quoted text -
I gotta love that analogy.
LOL -- Mark D Powell -- Received on Thu Oct 15 2009 - 11:06:00 CDT