When to pin objects in memory

[babe9c]

Originally posted by OracleDoc
Oracle has a great article on this task and makes recommendations as to what should be pinned.

SELECT owner, name, o.type, sharable_mem,
       loads, executions, kept
  FROM v$db_object_cache o
 WHERE loads > 0  AND o.type in ('PACKAGE', 'FUNCTION', 'PROCEDURE', 'TRIGGER', 'SEQUENCE')
 ORDER BY sharable_mem DESC

Of course you can modify it to check the number of executions and such.

Both the 8i and 9i reference manuals I've looked at indicate that the executions column of v$db_object_cache is not used. They suggest using the executions column of v$sqlarea instead. Anyone know why?

Also just wanted to say thanks to everyone for all the input!