2013年5月8日 星期三

oracle trace file [.trm] [.trc]

oracle version:11g

TRM Trace Files Getting Generated in 11g Database (Doc ID 750982.1)
Excessive Number Of Arc Trace Files Generated In 11g (Doc ID 754289.1)


Trace file in 11g belongs to ADR (Automatic Diagnostic Repository) you can manage it by using its Command Interpreter ADRCI:

http://download.oracle.com/docs/cd/E11882_01/server.112/e16536/adrci.htm#SUTIL700

It's possible to set the Purging Policy with the SET CONTROL statement:

http://download.oracle.com/docs/cd/E11882_01/server.112/e16536/adrci.htm#BGBEGAEB

You can purge Trace Files by using the PURGE statement:

http://download.oracle.com/docs/cd/E11882_01/server.112/e16536/adrci.htm#SUTIL1509

In addition, to remove Traces Files in the "CDMP_" directories, you may use the Type UTSCDMP as follow. For instance, to remove Trace files older than 1 hour in "CDMP_" directories:
adrci> purge -age 60 -type UTSCDMP


reference: https://forums.oracle.com/forums/thread.jspa?threadID=943615

沒有留言: