查看oracle中所有sql的执行情况

例如，我想看ORACLE中所有的SQL语句那些是走的FULL TABLE SCAN, 执行：         select sql_text from v$sqltext t, v$sql_plan p
         where t.hash_value=p.hash_value and p.operation='TABLE ACCESS'
           and p.options='FULL'
         order by p.hash_value, t.piece;