** keep/pin objects in sga
- From: A Joshi <ajoshi977@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 20 Oct 2006 13:20:15 -0700 (PDT)
Hi,
For efficient use of shared pool and SGA : On 9i : I assume it is
beneficial to keep objects and sql in sga. Or is it not needed on 9i? I think
parameter CURSOR SHARING can be set to FORCE as alternative to using bind
variables and that will help SGA use but there were issues with it. I assume
in 9i it is better. Any body with experience otherwise or any other catch?
Thanks for your help.
---------------------------------
How low will we go? Check out Yahoo! Messenger?s low PC-to-Phone call rates.
Other related posts:
