Re: Binding Variable Benefit Across Sessions ?

From: Thomas Kyte <tkyte_at_oracle.com>
Date: 6 Apr 2002 08:29:24 -0800
Message-ID: <a8n7p40d80@drn.newsguy.com>

In article <a8mugb$tgu0c$1_at_ID-54600.news.dfncis.de>, "Steffen says...
>
>"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?
>
>

see
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2588723819082

goes into it in some detail. (basically -- yes)

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Sat Apr 06 2002 - 10:29:24 CST