select * from (
select
        PLAN_HASH_VALUE hash,
        count(PLAN_HASH_VALUE) cnt
        ,substr(sql_text,0,50)
from v$sql
where plan_hash_value > 0
group by PLAN_HASH_VALUE
        ,substr(sql_text,0,50)
order by count(PLAN_HASH_VALUE) )
where cnt > 10
/