SELECT plan_hash_value, COUNT (*)
FROM v$sql
WHERE plan_hash_value 0
GROUP BY plan_hash_value
ORDER BY 2 DESC;
SELECT *
FROM v$sql
WHERE plan_hash_value = &b
FROM v$sql
WHERE plan_hash_value 0
GROUP BY plan_hash_value
ORDER BY 2 DESC;
SELECT *
FROM v$sql
WHERE plan_hash_value = &b
