• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3402
  • Last Modified:

Disabling .trc files in Oracle

I have an Oracle 10g development instance running on my Linux box here and I just discovered 12 GB of .trc files in the $ORACLE_HOME/admin/MYINSTANCENAME directory.  I deleted the logs, but now I am trying to figure out how to *disable* trc logging altogether to improve performance and prevent the system from wasting disk space.  I was Googling around the net and I found this command:

    alter system set sql_trace=false;

However, after logging in as 'system' and running that command the trc files are still created!  How do I prevent Oracle trc files from being created?  I feel like I am missing something obvious here.  :)  
1 Solution
Comment sql_trace in your init.ora file and restart the db.
dbeachy1Author Commented:
Worked like a charm!  Thanks.

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now