...and make it run in an autonomous transaction so that it persists
even if the calling transaction fails and gets rolled back, or use
DBMS_PIPE and another session with logger procedure running in
a loop if you're on pre-8i...
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"DA Morgan" <damorgan_at_exesolutions.com> wrote in message news:3E0791F6.33C68B0C_at_exesolutions.com...
> 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 Tue Dec 24 2002 - 05:13:45 CST
