Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ** keep/pin objects in sga

** keep/pin objects in sga

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Fri, 20 Oct 2006 13:20:15 -0700 (PDT)
Message-ID: <20061020202015.30473.qmail@web62411.mail.re1.yahoo.com>


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

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US