Re: ** keep/pin objects in sga

hi:

If you have literal sql issue, I suggest you use bind variables rather than cusor_sharing.

The parameter cursor_space_for_time is used to pin shared sql in shared_pool. You can find more info about this parameter..

For advance warning, you can check the x$ tables: x$kghlu, x$ksmss, x$ksmsp

On 10/22/06, A Joshi <ajoshi977_at_yahoo.com> wrote:
>
> Fuad,
> Thanks. So no short cut there. OK. So I guess we still need to do
> keeping of objects and sql. And put in bind variables. I assume there is
> some improvement in 9i in handling all this. Is there anything else that can
> be done to improve the sga usage and avoid its fragmentation and is there
> way to get advance warning when it is fragmented and could be heading for
> problems. Thanks
>
>
> *Fuad Arshad <fuadar_at_yahoo.com>* wrote:
>
> 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://us.rd.yahoo.com/mail_us/taglines/postman8/*http://us.rd.yahoo.com/evt=39663/*http://voice.yahoo.com>
>
>
> ------------------------------
> Want to be your own boss? Learn how on Yahoo! Small Business.<http://us.rd.yahoo.com/evt=41244/*http://smallbusiness.yahoo.com/r-index>
>
>

-- 
Eagle Fan

Oracle DBA

--
http://www.freelists.org/webpage/oracle-l