Home » SQL & PL/SQL » SQL & PL/SQL » count of calls from a procedure or package (10.2 )
count of calls from a procedure or package [message #387023] Tue, 17 February 2009 10:52 Go to next message
dunleav1
Messages: 2
Registered: February 2009
Junior Member
I have a procedure that calls functions, procedures, packages in a local schema and the sys schema.

I messed around with dbms_utility.format_call_stack and
asktom procedure who_called_me/who_am_i but I must be missing something.

How can I get a summary count of my calls?


Re: count of calls from a procedure or package [message #387026 is a reply to message #387023] Tue, 17 February 2009 11:00 Go to previous messageGo to next message
BlackSwan
Messages: 25038
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you
Re: count of calls from a procedure or package [message #387028 is a reply to message #387023] Tue, 17 February 2009 11:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use dbms_profile.

Regards
Michel
Re: count of calls from a procedure or package [message #387819 is a reply to message #387028] Fri, 20 February 2009 13:55 Go to previous message
dunleav1
Messages: 2
Registered: February 2009
Junior Member
Thanks. I'll check out dbms_profile.

I don't know what the user Blackswan was suggesting, I think my post is within the guidelines. It's a just a question about how to get a summary count of functions/procedures that a procedure calls.


[Updated on: Fri, 20 February 2009 14:17]

Report message to a moderator

Previous Topic: DBLINK performance over sybase (merged)
Next Topic: ORDER BY Question
Goto Forum:
  


Current Time: Mon Dec 05 14:52:31 CST 2016

Total time taken to generate the page: 0.11504 seconds