Recommandation ?

Hello,

This is some informations from v$db_object_cache :

NAMESPACE GETS GETHITS GETHITRATIO PINS PINHITS PINHITRATIO RELOA INVA
--------------- --------- --------- ----------- --------- --------- ----------- ---------- ------
SQL AREA 685111 683827 .99812585 6238049 6235304 .99955996 424 508
TABLE/PROC 4408 3591 .81465517 720716 719853 .99880258 14 0
BODY 51 39 .76470588 51 39 .76470588 0 0
TRIGGER 44 19 .43181818 44 9 .20454545 0 0
INDEX 57 18 .31578947 57 18 .31578947 0 0
CLUSTER 27 12 .44444444 15 5 .33333333 0 0
OBJECT 0 0 1 0 0 1
PIPE 0 0 1 0 0 1

What is your interpretations & recommandations ?

Thanks

Sofiane

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