Members   Search   Help    Register    Login   Home
Home » RDBMS Server » Server Administration » Trace procedure
Trace procedure [message #408366] Mon, 15 June 2009 21:36 Go to next message
*Jess*
Messages: 44
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';
Report message to a moderator
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: 3227
Registered: January 2009
Senior Member
What you posted will trace every new session in the DB.
Report message to a moderator
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: 28986
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
What kind of trace do you want?
What do you want to trace, precisely?

Regards
Michel
Report message to a moderator
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...
Report message to a moderator
Previous Topic:Dropping User
Next Topic:Creating DataBase Manually (merged)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 8 06:47:39 CST 2009

Total time taken to generate the page: 0.31094 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.