HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Clean trace files on Oracle 11g

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
11gfilesoracletraceclean

Problem

The partition containing my Oracle 11g installation began to fill up with trace files and when I went looking for what are these I've found this disturbing post about how to disable the trace file generation.

The two related questions I have are:

  • Can I simply delete these trace files from my FS w/o consequence ? (I know, if they apeared one should probably look at them.. but won't happen and the database has no production use whatsoever. Going to have to happen another time.)



  • What should be done to prevent it from appearing again?

Solution

-
Yes, it's safe to delete them.

-
If you're running on Linux, set up logrotate to compress & then delete after a set period of time. Examples of Oracle logrotate configuration can be found here.

Context

StackExchange Database Administrators Q#21544, answer score: 4

Revisions (0)

No revisions yet.