Re: Viewing Client SQL Commands Sent to Server

select sql_text
from v$sql_text
where address =
(select sql_address
 from v$session
 where sid = <suspected sid>)
order by piece;

to find the sid
select sid, serial#, program
from v$session where type = 'USER';

Hth

--
Sybrand Bakker, Oracle DBA Received on Wed Oct 06 1999 - 11:56:56 CDT