Re: ** keep/pin objects in sga
- From: Fuad Arshad <fuadar@xxxxxxxxx>
- To: ajoshi977@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 20 Oct 2006 17:41:19 -0700 (PDT)
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@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
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.
Other related posts:
