<div>
Worked like a charm! &nbsp;Thanks.
</div>


<div>
<div class="content wysiwyg-content">
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/MYINSTA<wbr />NCENAME directory. &nbsp;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. &nbsp;I was Googling around the net and I found this command:<br />
<br />
&nbsp; &nbsp; alter system set sql_trace=false;<br />
<br />
However, after logging in as 'system' and running that command the trc files are still created! &nbsp;How do I prevent Oracle trc files from being created? &nbsp;I feel like I am missing something obvious here. &nbsp;:) &nbsp;<br />

</div>
</div>


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.  :)  


Disabling .trc files in Oracle

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.