select 
  a.sid, 
  a.serial#,
  b.sql_text 
from 
  v$session a, 
  v$sqlarea b 
where 
  a.sql_address = b.address 
  and sid = $SID_NUMBER;