We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Disabling TRC files, howto?

Mark
Mark asked
on
Medium Priority
3,674 Views
Last Modified: 2013-12-19
I need to disable generation of trc files. They are chewing up most of my disk space and I'm really not even sure what they are for. There are lots of posting on this, but none really solve my problem.

In posting https://www.experts-exchange.com/Database/Oracle/10.x/Q_22712202.html I found the advice: "Comment sql_trace in your init.ora file and restart the db." That worked for the poster who is running my same version (10g).

However, I don't have "sql_trace" in my init.ora file. Also, I have two init.ora files in: /oracle/dbs/init.ora and /oracle/srvm/admin/init.ora. Both have the similar dates and I don't know which is the 'live' one.

Help appreciated
Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Commented:
then restart db

Author

Commented:
coupla questions before I do this (can't take the db down immediately):

Do I need a comma between "false" and "scope"?

How can I query "system" to see how tracing is set?

Commented:

1) no comma between scope and false
2) to chceck value of sql_trace check:
select name, value from v$parameter where lower(name) like 'sql_trace';
3) after shutting down database try to also add to both init.ora files sql_trace=false

Author

Commented:
Nope, still creating TRC files in /oracle/admin/orcl/bdump/. When I list the v$parameter value per your instructions it says "FALSE".

Suggestions?
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.