RE: ** keep/pin objects in sga
- From: Tanel Poder <tanel.poder.003@xxxxxxx>
- To: eagle.f@xxxxxxxxx, ajoshi9777@xxxxxxxxx
- Date: Tue, 24 Oct 2006 13:58:32 +0800
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.
Other related posts:
