Re: V$ views and PL/SQL

From: <mark.powell_at_eds.com>
Date: Wed, 03 Mar 1999 14:29:11 GMT
Message-ID: <7bjgvb$2u5$1@nnrp1.dejanews.com>

In article <7bhd49$9ve$1_at_nnrp1.dejanews.com>, mcarter69_at_my-dejanews.com wrote:
> 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.
>
> Michael
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

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 -- The only advice that counts is the advice that you follow so follow your own advice --

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 03 1999 - 08:29:11 CST