Home » RDBMS Server » Server Administration » Trace procedure
Trace procedure [message #408366] Mon, 15 June 2009 21:36 Go to next message
*Jess*
Messages: 48
Registered: December 2005
Location: Penang, Malaysia
Member

Hi all, we would want to trace a procedure/stored procedure.

Is 10046 trace level 12 applicable for this? Which means i'll b tracing that particular session eg. ABC.

Syntax: alter system set events '10046 trace name context forever,level 12';
Re: Trace procedure [message #408367 is a reply to message #408366] Mon, 15 June 2009 22:13 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
What you posted will trace every new session in the DB.
Re: Trace procedure [message #408370 is a reply to message #408366] Mon, 15 June 2009 23:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64101
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What kind of trace do you want?
What do you want to trace, precisely?

Regards
Michel
Re: Trace procedure [message #410551 is a reply to message #408366] Sun, 28 June 2009 09:40 Go to previous message
selvakumarmvs
Messages: 12
Registered: February 2009
Junior Member
this is not applicable before you restart the database...

try this

alter session set events '10046 trace name context forever,level 12';

this will work for all new session trace...
Previous Topic: Dropping User
Next Topic: Creating DataBase Manually (merged)
Goto Forum:
  


Current Time: Fri Dec 02 13:54:21 CST 2016

Total time taken to generate the page: 0.12269 seconds