Oracle DBA Tips

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 asADRCI, 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.