TRC File Documentation

Overview

Feature Value
File Extension .trc
Format Type Text
Generated By Oracle Database
Main Purpose Debugging and Diagnostics
Content Type Log Data
Encoding ASCII or UTF-8
Can Contain SQL Statements Yes
Can Contain Error Information Yes
Oracle Versions Compatibility All Supported Versions
Editable Yes, with Text Editor
Automatic Generation Yes, under specific conditions or errors
Can Be Manually Generated Yes, with specific database configuration
Used For Performance Analysis Yes
Can Be Rotated or Archived Yes, via Oracle or manual processes
Reading Software Text Editors, Oracle Tools
Typical Location [Oracle_Home]/diag/rdbms/[DBName]/[InstanceName]/trace
Used In Conjunction With TKPROF, Trace Analyzer
Can Be Compressed Yes, manually
Security Consideration May contain sensitive data; secure appropriately
Trace File Naming Convention varies, often includes process ID and/or timestamp