| pinning objects ?? but when ?? [message #171098] |
Mon, 08 May 2006 06:48  |
tridentadm
Messages: 142
Registered: March 2006
|
Senior Member |
|
|
for 'keeping' objects in shared_pool.
ie. dbms_shared_pool.keep
...
is the number of executions to be considered,
or
is the shareable memory it occupies to be considered
or
is it something else i am missing..??
|
|
|
|
| Re: pinning objects ?? but when ?? [message #171113 is a reply to message #171098] |
Mon, 08 May 2006 08:22  |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
What i have read is that: if there are small tables that the appilcation is accessing very often, then it helps to keep them in memory by pinning them.
so , both number of executions and memory it occupies (if the object is too big, then it will occupy bigger part of sga)-both are relevant.
imo.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
