Re: View users SQL

select a.sid,s.sql_text

    from v$session a, v$sqltext s
    where a.sql_address = s.address
    and a.sql_hash_value = s.hash_value
    and a.username = 'YOUR_USER'
     order by a.sid, s.piece
/

John Alexander
www.summitsoftwaredesign.com Received on Mon Mar 19 2001 - 18:21:34 CST