-
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
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 rohitsn@orasearch.net
Regards,
Rohit Nirkhe,Oracle DBA,OCP
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|