-
1. Re: oracle 18c XE: huge trace files how-to
Investigate why that trace file is being created is the first step. Perhaps there is an issue with the database. Check the alert log to see why it created that file.
Use the linux logrotate toll to manage the size and quantity of logs and trace trace files.
-
2. Re: oracle 18c XE: huge trace files how-to
why that trace file is created is the question. The alert log doesn't tell!
-
3. Re: oracle 18c XE: huge trace files how-to
Use logrotate to manage log and trace files.
What is contained in the trace file header?
You could
$ head -100 the_trace_file.trc > x.trc
and examine it for clues.
-
4. Re: oracle 18c XE: huge trace files how-to
Use find to find trace files older than n (e.g. 7) days, and delete them.
For example:
find /opt/oracle/diag/rdbms/xe/xe/trace -name *.tr? -mtime +7 -delete
Register and Participate in Oracle's online communities. Learn from thousand of experts, get answers to your questions and share knowledge with peers.