Re: Library Cache

<mrdjmagnet_at_aol.com> wrote in message
news:21d4d6db-6adb-4289-b5a4-76bae3d6b042_at_v5g2000prm.googlegroups.com...
>
> Hi,
>
> 2 questions here:
>
> First, in terms of minimizing the number of parse/execute calls, it is
> suggested to use bind variables. Is a bind variable the same as a
> plsql variable?
>
> If I have a stored procedure with either of these in them, will it
> remain in the library cache?
>
> SELECT name FROM customer WHERE customer_id = v_customer_id;
> SELECT name FROM customer WHERE customer_id = :cust_id;
>
> Is statement #1 eligible to remain in the library cache?
>
> Second, is using EXECUTE IMMEDIATE for doing a SELECT faster than a
> normal coded SELECT?
>
> Much Thanks!

pl/sql will make the v_customer_id a bind variable when it compiles it (when you create the stored proc).
No execute immediate will be slower and require more latching.(less scalable)
Jim Received on Wed Dec 24 2008 - 12:53:55 CST