--捕捉執行超過6秒的SQL

--捕捉執行很久的SQL
　　 select username,sid,opname,
　　round(sofar*100 / totalwork,0) || '%' as progress,
　　time_remaining,sql_text ,elapsed_seconds,start_time,message
　　from v$session_longops , v$sql
　　where
sql_address = address
　　and sql_hash_value = hash_value
[@more@]