Trace files are log files that record database connection activity. Trace files record the SQL statements issued to the database. You can configure the amount of information logged, how it is formatted, and whether or not database tracing occurs.
See Configuring Database Tracing Options.