Oracle .trc files 1

[KenCunningham]

Good morning (or whatever it is where you are). I'd appreciate advice on how long I should keep Oracle .trc files before they can be deleted. We have some dating back over six months and as far as I know once created they are never used by us again. Any advice greatly appreciated. Thanks.

 

[gansen]

You can keep a month data and delete the old ones.,
Trace files are only useful when something goes wrong like system crash which wont happen freqently.,

If its unix platform you can run a cron job to do this in an automated fashion.,

Hope this helps you.

 

[KenCunningham]

Gansen, many thanks. That was what I suspected, but it's good to get confirmation. Cheers.

 

[neilsie]

Ken,

do remember that your backup controlfiles, is named by default with an extension of ".trc".

br,
N.