How to watch another connection

From: waltervdv <marcus.kuehl_at_t-online.de>
Date: 11 Jul 2001 08:41:11 -0700
Message-ID: <b2677297.0107110741.140461b8@posting.google.com>

Hallo !

I have got the folowing problem:

I want to get the SQL-Statement, another connection is currently working on. I tried to do this with the following statement:

select

   SID
, USERNAME
, LOCKWAIT
, SQL_ADDRESS
, SQL_HASH_VALUE
, SQL_TEXT

from v$session a
, V$SQLTEXT b

where sid         = xxx
and  b.ADDRESS    = a.SQL_ADDRESS
and  b.HASH_VALUE = a.SQL_HASH_VALUE

order by b.PIECE

But the statement I get doesn't seem to be the right one !

Can anybody help me ?

Thank You

Marcus Received on Wed Jul 11 2001 - 10:41:11 CDT