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 Description

OWNER Owner of the object

NAME Name of the object

DB_LINK Database link name, if any

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

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

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

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

EXECUTIONS Not used.

LOCKS Number of users currently locking this
object

PINS Number of users currently pinning this
object

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

If u have want any help,please be free to write to me
at [email protected]

Regards,
Rohit Nirkhe,Oracle DBA,OCP