select a.*, sysdate-b.startup_time days_old
from v$sysstat a, v$instance b
where a.name like ’parse%’;

STATISTIC# NAME CLASS VALUE DAYS_OLD
---------- ------------------------- ----- ---------- ----------
230 parse time cpu 64 33371587 4.6433912
231 parse time elapsed 64 63185919 4.6433912
232 parse count (total) 64 2137380227 4.6433912
233 parse count (hard) 64 27006791 4.6433912
234 parse count (failures) 64 58945 4.6433912

select a.sid, c.username, b.name, a.value,
round((sysdate - c.logon_time)*24) hours_connected
from v$sesstat a, v$statname b, v$session c
where c.sid = a.sid
and a.statistic# = b.statistic#
and a.value > 0
and b.name = ’parse count (hard)’
order by a.value;

SID USERNAME NAME VALUE HOURS_CONNECTED
---- ---------- ------------------ ---------- ---------------
510 SYS parse count (hard) 12 4
413 PMAPPC parse count (hard) 317 51
37 PMHCMC parse count (hard) 27680 111
257 PMAPPC parse count (hard) 64652 13
432 PMAPPC parse count (hard) 105505 13