Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Why tot parses <> executions in bstat/estat #s?
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