Recommandation ?

[Sofiane]

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

[rohitsn]

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 rohitsn@orasearch.net

Regards,
Rohit Nirkhe,Oracle DBA,OCP