Library Cache
From: <mrdjmagnet_at_aol.com>
Date: Wed, 24 Dec 2008 09:58:52 -0800 (PST)
Message-ID: <21d4d6db-6adb-4289-b5a4-76bae3d6b042@v5g2000prm.googlegroups.com>
Date: Wed, 24 Dec 2008 09:58:52 -0800 (PST)
Message-ID: <21d4d6db-6adb-4289-b5a4-76bae3d6b042@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! Received on Wed Dec 24 2008 - 11:58:52 CST