Re: ---How do I know SQL command in process?

From: <shelbyko_at_my-dejanews.com>
Date: Tue, 04 May 1999 15:11:17 GMT
Message-ID: <7gn2mh$b90$1@nnrp1.dejanews.com>

select username,sql_text
from v$session a, v$sqlarea b
where a.sql_address = b.address;

If you want to see only the currently running sql add the following condition as well -- and a.status = 'ACTIVE'

In article <7glbbu$k6i$3_at_bgtnsc01.worldnet.att.net>, "Haruka Suko" <haruka-suko_at_worldnet.att.net> wrote:
> Hello! I have a question.
> How do I know the usernames and the SQL command which each has in process?
> I'll appreciate your help!!
>
> Haruka
> haruka-suko_at_worldnet.att.net
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue May 04 1999 - 10:11:17 CDT