| Setting sql trace parameter [message #237593] |
Tue, 15 May 2007 01:41  |
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 #237595 is a reply to message #237593] |
Tue, 15 May 2007 01:47  |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
