Oracle监视sql执行

select q.FIRST_LOAD_TIME,q.sql_text  
from v$session s, v$sqlarea q 
where s.user# = q.parsing_user_id and s.status='ACTIVE' 
           and s.username='用户名' 
order by q.FIRST_LOAD_TIME DESC;