RE: ** keep/pin objects in sga

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