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

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

RE: ** keep/pin objects in sga

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Tue, 24 Oct 2006 13:58:32 +0800
Message-id: <00a501c6f731$7120a1e0$6501a8c0@windows01>


I suggest you NOT to use cursor_space_for_time just for pinning objects into shared pool. This parameter's purpose is not an easy way for pinning all the junk in your shared pool.  

It's purpose is to keep library cache cursors pinned that subsequent executions of already open cursors wouldn't require "library cache pin" latching.  

This parameter will kill your instance especially when you are not using bind variables and proper cursor management - you'll just flood your shared pool with junk, which will be kept pinned, until all work fails with ORA-4031 and you can't even log on as DBA.  

Tanel.  

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 24 2006 - 00:58:32 CDT

Original text of this message

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