Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Set trace_enabled=FALSE to turn off trace file

user13148231Jul 1 2010 — edited Jul 6 2010
We run a Java application on Oracle 11g2 on Redhat, and have some deadlock on JBPM tables. The dev team aware this problem and decide not to fix it as there are some other higher priority job. But this result in huge number of trace files in "user_dump_dest" and some of them are very large (300G). We saw 3 times disk full in past week. Now I want to turn the trace. I set the init parameter trace_enabled=FALSE and now we have te following parameters
SQL> show parameter trace

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_trace                    integer     0
sec_protocol_error_trace_action      string      TRACE
sql_trace                            boolean     FALSE
trace_enabled                        boolean     FALSE
tracefile_identifier                 string
Now I see less files like SID_ora_6327.trc , but still many But I still see many trace files like
tdev2_j000_20563.trm, tdev2_m002_30556.trm, tdev2_arcq_6622.trc and tdev2_vktm_6309.trc.

How to turn them off?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 3 2010
Added on Jul 1 2010
12 comments
21,057 views