老方法:SELECT substr(sql_text,1,40) "SQLTXT", count(*) , sum(executions) "TotExecs" FROM v$sqlarea WHERE executions < 5 GROUP BY substr(sql_text,1,40) HAVING count(*) > 30 ORDER BY 2 DESC新方法:SELECT FORCE_MATCHING_SIGNATURE,COUNT(*) FROM V$SQLGROUP BY FORCE_MATCHING_SIGNATUREORDER BY 2 DESC