Query to find which sql is executing in a session

select a.sid, a.serial#, b.sql_text

   from v$session a, v$sqlarea b

    where a.sql_address=b.address

     and a.sid = :sid