Oracle 10g, Trace File (.trc)

From: Fabrice <>
Date: Thu, 15 Oct 2009 15:57:50 +0200
Message-ID: <hb7ah6$6vr$>


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.

  • 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. - Production vsnsta=0 vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release - 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
Received on Thu Oct 15 2009 - 08:57:50 CDT

Original text of this message