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