Home » RDBMS Server » Performance Tuning » pinning objects ?? but when ??
pinning objects ?? but when ?? [message #171098] Mon, 08 May 2006 06:48 Go to next message
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 Go to previous message
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.
Previous Topic: ip address
Next Topic: V_$view VS v$views
Goto Forum:
  


Current Time: Wed May 22 18:17:16 CDT 2024