Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: high tkprof parse counts == real # of hard parses?
[Connor McDonald]
> v$sesstat splits this down into hard and soft parses.
Ah - thanks Connor!
select name, sum(value) total
from v$sesstat,v$statname
where v$sesstat.statistic#=v$statname.statistic#
and name like '%parse%'
group by name
parse count (hard) 2169 parse count (total) 69494630 parse time cpu 1082154 parse time elapsed 1420764
That looks *much* better to me!
James
-- James Manning <jmm_at_sublogic.com> GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning INET: jmm_at_sublogic.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Feb 08 2002 - 13:51:37 CST
![]() |
![]() |