Re: Library cache

Thanks HansF
>From asktom

http://asktom.oracle.com/pls/ask/f?p=4950:8:3584800475466966168::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:2588723819082

According to TOM
(no Parse)
parse
loop

   bind
   execute
   <fetch if query>
end loop
close

is better than

(soft parse)

loop

   parse
   bind
   execute
   <fetch>
   close
end loop

1. what is parse in loop parse bind
2. If i have a query Do while not x.eof update x=x+1 loop

Is this query of "NO PARSE" type or "Soft parse type"

thanks Received on Wed Feb 15 2006 - 10:12:30 CST