Thursday, January 24, 2019

Oracle : Difference between .trc and .trm


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.

No comments:

Post a Comment