Re: ** keep/pin objects in sga

From: Fuad Arshad <fuadar_at_yahoo.com>
Date: Fri, 20 Oct 2006 17:41:19 -0700 (PDT)
Message-ID: <20061021004119.82142.qmail@web82103.mail.mud.yahoo.com>

cursor sharing still has a lot of bugs.
it depends on the environment but tom kyte also asked for the use of this only at session level rather than system level

Original Message ---- From: A Joshi <ajoshi977_at_yahoo.com> To: oracle-l_at_freelists.org Sent: Friday, October 20, 2006 3:20:15 PM Subject: ** keep/pin objects in sga

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! Messengers low PC-to-Phone call rates.
--

http://www.freelists.org/webpage/oracle-l Received on Fri Oct 20 2006 - 19:41:19 CDT