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

On Oct 15, 9:57 am, "Fabrice" <emouc... at (no spam) 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 -

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