Re: Oracle 10g, Trace File (.trc)
Date: Thu, 15 Oct 2009 17:01:57 +0200
Message-ID: <hb7e9d$8f4$1_at_s1.news.oleane.net>
Thanks for your answer ;-).
But I'm not used to have many .trc file with my 8i. 10g creates 3 or 4 trc files just when the database starts ou shutdown. With 8i I have just informations in my alert.log. No trc file.
fabrice.
"hpuxrac" <johnbhurley_at_sbcglobal.net> a écrit dans le message de news: 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 - 10:01:57 CDT