OraFAQ Forum: Server Administration » trm and trc file filling space freequently

Home » RDBMS Server » Server Administration » trm and trc file filling space freequently (Oracle 11g , Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

trm and trc file filling space freequently [message #488748]

Mon, 10 January 2011 23:23

pradies
Messages: 250
Registered: May 2008

Senior Member

Hi,

I am using the oracle 11g on windows server 2003 server. and front end application is running in java. and There are lot of trm and trc files in the oracle dump area.

How can i stop them to recreate becuase the massage written in trc and trm file is not understandable to me.

can some one help me in this ?

regards

Pradeep

Report message to a moderator

Re: trm and trc file filling space freequently [message #488750 is a reply to message #488748]

Mon, 10 January 2011 23:44

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Turn off SQL tracing.

For that you will most likely have to find out where tracing is enabled in the application and why.

Report message to a moderator

Re: trm and trc file filling space freequently [message #488765 is a reply to message #488750]

Tue, 11 January 2011 02:04

pradies
Messages: 250
Registered: May 2008

Senior Member

Hi,

I have chceked at DB level tracing is off i.e sql_trace = false

So can you please tell me how can I check whose creating the trc and trm files

pradeep

Report message to a moderator

Re: trm and trc file filling space freequently [message #488804 is a reply to message #488765]

Tue, 11 January 2011 04:39

cookiemonster
Messages: 13922
Registered: September 2008
Location: Rainy Manchester

Senior Member

What sort of things are in the trc files?
Are they deadlocks?

Report message to a moderator

Re: trm and trc file filling space freequently [message #488808 is a reply to message #488804]

Tue, 11 January 2011 04:45

pradies
Messages: 250
Registered: May 2008

Senior Member

Hi,

mostly I am getting the same below error (checked at random)

-----------------------------------------------------
Trace file d:\app\administrator\diag\rdbms\vxmldb\vxmldb\trace\vxmldb_ora_9776.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V5.2 Service Pack 2
CPU : 4 - type 8664, 1 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:3007M/8182M, Ph+PgF:10470M/15928M
Instance name: vxmldb
Redo thread mounted by this instance: 1
Oracle process number: 109
Windows thread id: 9776, image: ORACLE.EXE (SHAD)

*** 2011-01-11 10:48:47.234
*** SESSION ID:(2783.6103) 2011-01-11 10:48:47.234
*** CLIENT ID:() 2011-01-11 10:48:47.234
*** SERVICE NAME:(SYS$USERS) 2011-01-11 10:48:47.234
*** MODULE NAME:(JDBC Thin Client) 2011-01-11 10:48:47.234
*** ACTION NAME:() 2011-01-11 10:48:47.234

XS Users and Roles -- OCI Info
kzxupnamread error -- OCI No Data
XS Users and Roles -- OCI Info
kzxupnamread error -- OCI No Data
--------------------------------------------------

thankx
pradeep

Report message to a moderator

Previous Topic:	Help for Error
Next Topic:	Difference b/w V$PARAMETER & V$PARAMETER2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 08 05:23:48 CDT 2024