Xref: alice comp.databases.oracle.server:42088
Path: alice!news-feed.fnsi.net!netnews.com!newspeer1.nac.net!newspeer.monmouth.com!nntp2.dejanews.com!nnrp1.dejanews.com!not-for-mail
From: mark.powell@eds.com
Newsgroups: comp.databases.oracle.server
Subject: Re: V$ views and PL/SQL
Date: Wed, 03 Mar 1999 14:29:11 GMT
Organization: Deja News - The Leader in Internet Discussion
Lines: 22
Message-ID: <7bjgvb$2u5$1@nnrp1.dejanews.com>
References: <7bhd49$9ve$1@nnrp1.dejanews.com>
X-Article-Creation-Date: Wed Mar 03 14:29:11 1999 GMT
X-Http-User-Agent: Mozilla/2.0 (compatible; MSIE 3.02; Windows 95)
X-Http-Proxy: 1.0 x4.dejanews.com:80 (Squid/1.1.22) for client 199.228.142.8

In article <7bhd49$9ve$1@nnrp1.dejanews.com>,
  mcarter69@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