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