Oracle Trace file (.trc) or Trace map (.trm) cleanup

To clean up old Oracle trace file (.trc) and trace map (.trm) files, use this command on UNIX based system:

Connect sqlplus :

Ekran Resmi 2017-11-29 12.20.07

 

And,

find /u01/app/oracle/diag/rdbms/sbuat01/SBUAT01/trace/*.trc -mtime +14 -exec rm {} \;

find /oracle/diag/rdbms/ssekdb/ssekdb/trace/*.trm -mtime +14 -exec rm {} \;

The above command will delete trace files and trace map files which is older than 14 days.

Hits: 3

Leave a Reply

Your email address will not be published. Required fields are marked *