a better way to find literal sqls in oracle 10g
Finding literal sqls, example for ORACLE 10g & 11g
SELECT force_matching_signature, COUNT(1)
FROM v$sql
WHERE force_matching_signature > 0
AND force_matching_signature <> exact_matching_signature
GROUP BY force_matching_signature
HAVING COUNT(1) > 10
ORDER BY 2
No comments:
Post a Comment