OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Trace procedure

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Trace procedure [message #408366]

Mon, 15 June 2009 21:36

*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';

Report message to a moderator

Re: Trace procedure [message #408367 is a reply to message #408366]

Mon, 15 June 2009 22:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: Trace procedure [message #410551 is a reply to message #408366]

Sun, 28 June 2009 09:40

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 22:21:20 CDT 2024