Wednesday 20 March 2013

11g database generating excessive .trc and .trm files

Hi, One of my development database generating excessive .trm and .trc files. As well as writing shell script to delete them I used adrci utility to drop them.

adrci is the utility provided to purge the diag_dest

$ adrci
adrci > purge -age 60 -type trace

above command will delete all the trace files older than one hour.

and to create a permanent policy you can use following command on the adrci prompt.

adrci> set control (SHORTP_POLICY = 24) ### Here time is in hours.


If we set control like above it will delete the files with 1 day difference.

also I found one intresting thing that is incident directory under /u01/app/oracle/diag/rdbms/dev/dev/incident

It contains more number of .trc and .trm files . I deleted them by using below command with adrci utility:


adrci > purge -age 60 -type incident












No comments:

Post a Comment