How
to track user activity?
Is there a way to see what
PL/SQL procedure a user is running at a specific
point in time. I know you
can get the sql text from a users session, but I
need to know what PL/SQL proc
this users called.
If you need to track code
and viewing the v$sqlarea is not good enough you
may want to look into using
the dbms_application_info package to have
applications insert messages
into the v$session table. This is useful for
longer running pieces of code.
Mark D. Powell