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 -> Re: difference between soft and hard parse

Re: difference between soft and hard parse

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 06 Sep 2001 21:00:15 +0100
Message-ID: <3B97D5CF.58E9@yahoo.com>


Ted Chyn wrote:
>
> all, soft parse is better than hard parse. what are the definition and
> difference between the two ?
>
> thnx ted chyn

(Simplistically...)

hard parse - the whole kaboodle - brand new sql comes along - gotta do all the stuff - syntax check, privs, blah blah blah

soft parse - sql already in the pool - but mine - gotta do some of the hard parse stuff but not all of it.

hth

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."
Received on Thu Sep 06 2001 - 15:00:15 CDT

Original text of this message

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