V$DB_OBJECT_CACHE

This view lists objects currently cached in the library cache.

Fields

The most relevant view fields are as follows:

• OWNER: The owner of the object

• NAME: The object name

• TYPE: The object type, for example, INDEX, TABLE, VIEW, CLUSTER, SEQUENCE, PROCEDURE, FUNCTION, PACKAGE, TRIGGER, or CLASS

• SHARABLE_MEM: The amount of memory in the shared pool used by the object

• KEPT: If the object was pinned in the library cache using the DBMS_SHARED_POOL.KEEP procedure, the value is YES, otherwise NO

• LOADS: The number of times the object was loaded

• LOCKS: The number of users locking the object

• PINS: The number of users pinning the object

• INVALIDATIONS: The number of times the object was marked invalid because a dependent object was modified

See also

• The ALL_OBJECTS section in this appendix