Dynamic Performance (V$) Views, 39 of 179

V$DB_OBJECT_CACHE

This view displays database objects that are cached in the library cache. Objects include tables, indexes, clusters, synonym definitions, PL/SQL procedures and packages, and triggers.

Column Datatype Description

OWNER

VARCHAR2

Owner of the object

NAME

VARCHAR2

Name of the object

DB_LINK

VARCHAR2

Database link name, if any

NAMESPACE

VARCHAR2

Library cache namespace of the object: TABLE/PROCEDURE, BODY, TRIGGER, INDEX, CLUSTER, OBJECT

TYPE

VARCHAR2

Type of the object: INDEX, TABLE, CLUSTER, VIEW, SET, SYNONYM, SEQUENCE, PROCEDURE, FUNCTION, PACKAGE, PACKAGE BODY, TRIGGER, CLASS, OBJECT, USER, DBLINK

SHARABLE_MEM

NUMBER

Amount of sharable memory in the shared pool consumed by the object

LOADS

NUMBER

Number of times the object has been loaded. This count also increases when an object has been invalidated

EXECUTIONS

NUMBER

Not used.
See: "V$SQLAREA" to see actual execution counts.

LOCKS

NUMBER

Number of users currently locking this object

PINS

NUMBER

Number of users currently pinning this object

KEPT

VARCHAR2(3)

YES or NO, depending on whether this object has been "kept" (permanently pinned in memory) with the PL/SQL procedure DBMS_SHARED_POOL.KEEP

Column	Datatype	Description
`OWNER`	`VARCHAR2`	Owner of the object
`NAME`	`VARCHAR2`	Name of the object
`DB_LINK`	`VARCHAR2`	Database link name, if any
`NAMESPACE`	`VARCHAR2`	Library cache namespace of the object: `TABLE`/`PROCEDURE`, `BODY`, `TRIGGER`, `INDEX`, `CLUSTER`, `OBJECT`
`TYPE`	`VARCHAR2`	Type of the object: `INDEX`, `TABLE`, `CLUSTER`, `VIEW`, `SET`, `SYNONYM`, `SEQUENCE`, `PROCEDURE`, `FUNCTION`, `PACKAGE`, `PACKAGE` `BODY`, `TRIGGER`, `CLASS`, `OBJECT`, `USER`, `DBLINK`
`SHARABLE_MEM`	`NUMBER`	Amount of sharable memory in the shared pool consumed by the object
`LOADS`	`NUMBER`	Number of times the object has been loaded. This count also increases when an object has been invalidated
`EXECUTIONS`	`NUMBER`	Not used. See: "V$SQLAREA" to see actual execution counts.
`LOCKS`	`NUMBER`	Number of users currently locking this object
`PINS`	`NUMBER`	Number of users currently pinning this object
`KEPT`	`VARCHAR2(3)`	YES or NO, depending on whether this object has been "kept" (permanently pinned in memory) with the PL/SQL procedure `DBMS_SHARED_POOL`.KEEP