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

Home -> Community -> Usenet -> c.d.o.server -> Why tot parses <> executions in bstat/estat #s?

Why tot parses <> executions in bstat/estat #s?

From: H2oStyle <sdempsey_at_my-deja.com>
Date: Thu, 21 Dec 2000 16:39:36 GMT
Message-ID: <91tbo6$c4j$1@nnrp1.deja.com>

Anyone know why in the bstat/estat report the number of total parses doesn't equal the execute count?

The other related or underlying question was that if it's not a hard parse, what is it? Most people say its a soft parse meaning that it found a shared sql statement in the cache to use. But then we come back to the original question.

I'm wondering if perhaps it might have something related to do with the way the client tries to exec sql or rather the way it passes it to oracle.

Thanks,
Scott

Sent via Deja.com
http://www.deja.com/ Received on Thu Dec 21 2000 - 10:39:36 CST

Original text of this message

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