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
rolex.mp
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 10.2.0.2.0.

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

Regards
Michel

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

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

or you should use DBMS_MONITOR/DBMS_SESSION package.

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




Regards
Taj


[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: Fri Dec 09 09:31:12 CST 2016

Total time taken to generate the page: 0.05685 seconds