script to check oracle database last executed sql code?

select S.USERNAME||'('||s.sid||')-'||s.osuser     UNAM
--      ,s.program||'-'||s.terminal||'('||s.machine||')' PROG
      ,s.sid||'/'||s.serial# sid
     ,s.status "Status",p.spid
     ,sql_text sqltext
from v$sqltext_with_newlines t,V$SESSION s , v$process p
where t.address =s.sql_address
and p.addr=s.paddr(+)
and t.hash_value = s.sql_hash_value
order by s.sid,t.piece
/