oracle查看当前SQL

set lines 10000
set pages 0


select   sq.SQL_TEXT 
  from v$open_cursor oc, v$sql sq, v$session s
where oc.HASH_VALUE = sq.HASH_VALUE
   and s.SID = oc.SID
   and s.STATUS = 'ACTIVE' and s.USERNAME='VIDS' and sq.SQL_TEXT like 'select%' order by sq.SQL_TEXT;




exit;