Disabling .trc files in Oracle

Posted on 2007-07-21
Last Modified: 2013-12-18
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.  :)  
Question by:dbeachy1
    LVL 27

    Accepted Solution

    Comment sql_trace in your init.ora file and restart the db.

    Author Comment

    Worked like a charm!  Thanks.

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Suggested Solutions

    Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
    How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now