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 Failures ' "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;