Re: Hard Parses way more than executions!?
From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Wed, 30 Nov 2011 13:32:58 +0000
Message-ID: <4ED6308A.4080900_at_dunbar-it.co.uk>
On 30/11/11 13:27, PD Malik wrote:
> Hello Oracle List,
> How can the number of Hard Parses (or Loads) be way more than the number of
> executions please :
Date: Wed, 30 Nov 2011 13:32:58 +0000
Message-ID: <4ED6308A.4080900_at_dunbar-it.co.uk>
On 30/11/11 13:27, PD Malik wrote:
> Hello Oracle List,
> How can the number of Hard Parses (or Loads) be way more than the number of
> executions please :
Some tool kits for connecting to Oracle allow you to parse a statement but never execute it subsequently. This is done for a number of reasons:
- to check syntax etc;
- to be able to DESCRIBE the statement to dynamically build result arrays, variables etc;
- because the tool kit does it anyway because it was written that way.
I think I remember ADO being a "parse twice execute once" sort of thing - but that was years ago. (2003)
Cheers,
Norm.
-- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 30 2011 - 07:32:58 CST