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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Binding Variable Benefit Across Sessions ?

Re: Binding Variable Benefit Across Sessions ?

From: Steffen Ramlow <s.ramlow_at_gmx.de>
Date: Sat, 6 Apr 2002 15:50:14 +0200
Message-ID: <a8mugb$tgu0c$1@ID-54600.news.dfncis.de> 





"Thomas Kyte" <tkyte_at_oracle.com> wrote in message
news:a8klcl0124u_at_drn.newsguy.com...



> the soft parse is unavoidable -- you gotta get started somehow.




what is a soft parse?



a hard parse: a new exec plan is calculated - but a soft parse? does it mean
finding the stmt in the cache, bind variables and execute it?
Received on Sat Apr 06 2002 - 07:50:14 CST












Original text of this message













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