Oracle 9i

sqlplus "/ as sysdba"

 select sid,serial#,status,machine,module,program,last_call_et/60,SQL_ADDRESS,SQL_HASH_VALUE from gv$session where status='ACTIVE';


SELECT s1.sql_text from v$sqlarea s1,v$session s2 where s2.SID=28 and s2.SQL_ADDRESS = s1.ADDRESS




select s.sid,sq.sql_text from v$session s, v$sqlarea sq
where s.SQL_ADDRESS = sq.ADDRESS and s.sql_hash_value=sq.hash_value
and s.sid=&SESSION_ID
/



select s.sid,sq.sql_text
from v$session s, v$sqlarea sq, v$open_cursor oc
where s.sid=&SESSION_ID
and s.saddr = oc.saddr
and sq.address=oc.address and sq.hash_value=oc.hash_value
/