Home » RDBMS Server » Performance Tuning » Setting sql trace parameter
Setting sql trace parameter [message #237593] Tue, 15 May 2007 01:41 Go to next message
Messages: 161
Registered: February 2007
Senior Member
I want to generate a trace with list of statements that are fired when I apply patch .

I am using Oracle Database 10g Enterprise Edition Release

When I set the parameter sql_trace=true in the init.ora file and when I start the database I am facing this error

ORA-32006: SQL_TRACE initialization parameter has been deprecated

What should be done ?
Re: Setting sql trace parameter [message #237594 is a reply to message #237593] Tue, 15 May 2007 01:46 Go to previous messageGo to next message
Michel Cadot
Messages: 63914
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is a very very bad idea to enable trace when applying a patch.
You may screw up your database.


Re: Setting sql trace parameter [message #237595 is a reply to message #237593] Tue, 15 May 2007 01:47 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

You can set "alter system set SQL_TRACE = TRUE;"

or you should use DBMS_MONITOR/DBMS_SESSION package.

This parameter is deprecated. Oracle recommends that you use the DBMS_MONITOR and DBMS_SESSION packages instead. SQL_TRACE is retained for backward compatibility only.


[edit: Before setting this parameter please keep in mind Micheal comments.]

[Updated on: Tue, 15 May 2007 01:49]

Report message to a moderator

Previous Topic: Rule based but has cost in explain plan.. why?
Next Topic: Slow query responce
Goto Forum:

Current Time: Mon Oct 24 07:34:07 CDT 2016

Total time taken to generate the page: 0.22931 seconds