Query to find to Soft Parse and Hard Parse Ratio

Query to find to Soft Parse and Hard Parse ratio

select 'Soft Parses ' "Ratio"

,round(

((select sum(value) from v$sysstat where name = 'parse count (total)')

- (select sum(value) from v$sysstat where name = 'parse count (hard)'))

/(select sum(value) from v$sysstat where name = 'execute count')

*100,2)||'%' "percentage"

from dual

union

select 'Hard Parses ' "Ratio"

,round(

(select sum(value) from v$sysstat where name = 'parse count (hard)')

/(select sum(value) from v$sysstat where name = 'execute count')

*100,2)||'%' "percentage"

from dual

union

select 'Parse Failure ' "Ratio"

,round(

(select sum(value) from v$sysstat where name = 'parse count (failures)')

/(select sum(value) from v$sysstat where name = 'parse count (total)')

*100,2)||'%' "percentage"

from dual

/

select sql_text from v$sqlarea where version_count > 1;