Recommandation ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Recommandation ?

  1. #1
    Join Date
    Sep 2000
    Posts
    64

    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

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    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
  •  



Click Here to Expand Forum to Full Width