Re: view users statement
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 22 Nov 2000 19:16:05 +0100
Message-ID: <8vh43v$4is9e$9_at_ID-62141.news.dfncis.de>
order by piece
Date: Wed, 22 Nov 2000 19:16:05 +0100
Message-ID: <8vh43v$4is9e$9_at_ID-62141.news.dfncis.de>
"Andreas Lommel" <him_lommel_at_t-online.de> wrote in message
news:39ed640d.6474109_at_news.btx.dtag.de...
> Hi there, how can I see a users current sql-statement ?
select sqltext
from v$sql_text_with_newlines t, v$session s
where t.address = s.sql_address
and t.hash_value = s.hash_value and s.sid = <your sid>
order by piece
Hth,
Sybrand Bakker, Oracle DBA Received on Wed Nov 22 2000 - 19:16:05 CET