OraFAQ Forum: Server Administration » stored procedure problem

Home » RDBMS Server » Server Administration » stored procedure problem

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

stored procedure problem [message #64074]

Mon, 13 December 2004 02:12

sachin tom
Messages: 3
Registered: December 2004

Junior Member

respected Sir

how do i know, how many times my stored procedure has executed.

thank you

Report message to a moderator

Re: stored procedure problem [message #64075 is a reply to message #64074]

Mon, 13 December 2004 03:46

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Try auditing the procedure. You can audit calls to the procedure. Look at the Oracle docs for details about auditing.

MHE

Report message to a moderator

Re: stored procedure problem [message #64079 is a reply to message #64074]

Mon, 13 December 2004 06:21

croK
Messages: 170
Registered: April 2002

Senior Member

Trace the session executing the procedure, and then, tkprof the *.trc file generate by the trace session.
You can find something like:
call count cpu elapsed
-------- ---------- ---------- ----------
Parse 12 0.12 0.10
Execute 12 0.07 0.08
Fetch 0 0.00 0.00
---------- ---------- ---------- ----------
total 24 0.19 0.18

Execute count=12 is what you are looking for..

Hope it helps.

Report message to a moderator

Previous Topic:	How to change SGA
Next Topic:	stored procedure problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 24 23:08:47 CST 2025