Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: high tkprof parse counts == real # of hard parses?

Re: high tkprof parse counts == real # of hard parses?

From: James Manning <jmm_at_sublogic.com>
Date: Fri, 08 Feb 2002 09:22:52 -0800
Message-ID: <F001.0040A475.20020208083839@fatcity.com>

[Danişment Gazi Ünal]
> it looks like not normal. can you run your trace file by
> http://www.unal-bilisim.com/products/itrprof/itrprof.html . if results same, can you
> email me your raw file ?

When I ran it through that, it claimed only 18 hard parses which makes me feel a *lot* better. But then, why isn't tkprof more clear on soft vs. hard parses? :( In any case, it looks like it's not the problem I thought it was.

-- 
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 - 11:22:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US