Search This Blog

Total Pageviews

Friday, 4 November 2011

Oracle 11g trm and trc file

lots of trm and trc file
Oracle *.trm *.trc


A new type of files with .trm extension are created in ADR_HOME/trace directory in Oracle 11g databases. The following are some facts:

* From 11g onwards, all the trace files are found in ADR_HOME/trace directory.

* There is usually one “.trm” file for each “.trc” file.

* The files located in the TRACE directory, with the “.trm” extensions, are called Trace
Metadata files. The metadata in .trm files describe the trace records stored inside of .trc
trace files.

* The Trace metadata allows tools, such as ADRCI, to post process the trace information.

* By deleting the .trm file, you make the .trc file unusable for post processing from ADR using
ADRCI tool.




in this dir
/XX/oracle/diag/rdbms/xxx/aptdb/trace


11g produces quite a bit of diag traces.

Is this how you disabled the tracing?

event = "10468 trace name context forever, level 4" in pfile

Unix vi line number

Show Line Numbers in vi
in vi line number




:set nu ---------- turn on line number

:set nu! ---------- turn off line number

Oracle DBA

anuj blog Archive