Databases Reference
In-Depth Information
V$DB_OBJECT_CACHE
This view lists objects currently cached in the library cache.
Fields
The most relevant view fields are as follows:
F
OWNER
: The owner of the object
F
NAME
: The object name
F
TYPE
: The object type, for example,
INDEX
,
TABLE
,
VIEW
,
CLUSTER
,
SEQUENCE
,
PROCEDURE
,
FUNCTION
,
PACKAGE
,
TRIGGER
, or
CLASS
F
SHARABLE_MEM
: The amount of memory in the shared pool used by the object
F
KEPT
: If the object was pinned in the library cache using the
DBMS_SHARED_POOL.
KEEP
procedure, the value is
YES
, otherwise
NO
F
LOADS
: The number of times the object was loaded
F
LOCKS
: The number of users locking the object
F
PINS
: The number of users pinning the object
F
INVALIDATIONS
: The number of times the object was marked invalid because
a dependent object was modified
See also
F
The
ALL_OBJECTS
section in this appendix
V$ENQUEUE_LOCK
This view shows the locks owned by enqueue state objects.
Fields
The most relevant view fields are as follows:
F
ADDR
: The address of the lock state object
F
KADDR
: The address of the lock
F
SID
: The identifier for the session holding or acquiring the lock
F
TYPE
: The type of lock
F
ID1
: Lock identifier #1 (depends on
TYPE
)