Oracle - How much hard parsing is Oracle performing (https://app.pluralsight.com/library/courses/oracle-performance-tuning-developers/table-of-contents)

hard_parsing.sql

-- Value is in microseconds
-- Run this query at a couple regular intervals and take the delta to get
-- an idea of how much hard parsing is going on
select sn.statistic#, sn.name, s.value
from v$sysstat s, v$statname sn
where s.statistic# = sn.statistic#(+)
and sn.name in ('parse time cpu', 'parse count (hard)');