Re: ** keep/pin objects in sga

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@xxxxxxxxx> 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@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.
  




                                
---------------------------------
Want to be your own boss? Learn how on  Yahoo! Small Business.

Other related posts: