SQL> show parameter trace_en
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
trace_enabled boolean TRUE
SQL>
通过find命令查找30天以前创建的文件,通过xargs管道和rm-rf命令,可以直接删除
[oracle@HBCADB001 hbcadb1]$ find trace -ctime +30|more
trace/hbcadb1_j000_25349.trc
trace/hbcadb1_j000_28514.trm
trace/hbcadb1_ora_12171.trm
trace/hbcadb1_ora_4595.trm
trace/hbcadb1_j000_3029.trm
trace/hbcadb1_ora_14967.trm
trace/hbcadb1_j000_2237.trm
trace/hbcadb1_j000_13278.trc
trace/hbcadb1_ora_13051.trm
find trace -ctime +30 |xargs rm -f