Re: Can you tell how often a package is called?

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Mon, 23 Dec 2002 19:03:56 -0000
Message-ID: <3e08a31b_1@mk-nntp-1.news.uk.worldonline.com>

"Chuck B" <chuck_jen49_at_yahoo.com> wrote in message news:b1245bc4.0212230634.11fe714a_at_posting.google.com...
> I am trying to monitor the usage of a system critical package and
> would like to know if it is possible with any of the dba or V$ views
> to tell how often it's called. What I'm looking for is some way to
> tell the last time it was executed and then tie this back to v$session
> to see who did it.
>
> Has anyone done anything similar to this?
>
> Thanks,
> Chuck

How about having the package write to a log each time it is called? Then you can record whatever information you like.

Regards,
Paul Received on Mon Dec 23 2002 - 13:03:56 CST