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

Chuck B wrote:

> 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

Easiest way is to put an insert statement to a log table into the package.

Daniel Morgan Received on Mon Dec 23 2002 - 16:45:10 CST