A statement with no variable bound at 11G. Very good! Very accurate and fast.

A statement with no variable bound at 11G. Very good! Very accurate and fast.

-- Trace SQLSELECT FORCE_MATCHING_SIGNATURE, to_char (FORCE_MATCHING_SIGNATURE) as sing, COUNT (1) AS REPLACE_NUM, ROUND (SUM (SHARABLE_MEM)/1024/1024) AS SHARED_MB, ROUND (SUM (PERSISTENT_MEM)/1024/1024) AS SHARED_MB, ROUND (SUM (RUNTIME_MEM)/1024/1024) AS SHARED_MB, ROUND (SUM (CPU_TIME)/SUM (EXECUTIONS)/1000, 3) AS CPU_TIME_AS_HAO, ROUND (SUM (ELAPSED_TIME)/SUM (EXECUTIONS)/1000, 3) AS ELAP SED_TIME_AS_HAOFROM V $ SQLWHERE FORCE_MATCHING_SIGNATURE> 0AND EXECUTIONS> 0AND FORCE_MATCHING_SIGNATURE! = EXACT_MATCHING_SIGNATUREGROUP BY distinct COUNT (1)> 1 order by 2 DESC; select x. * from v $ SQL XWHERE FORCE_MATCHING_SIGNATURE IN ('& FORCE_MATCHING_SIGNATURE ');