V$db_object_cache
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: V$db_object_cache

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    V$db_object_cache

    Hi,

    V$DB_OBJECT_CACHE
    Documentation says this view displays objects that are cached in library cache. Objects include table,indexes etc

    As far as i know, in library cache, we have only the text code, parsed code and execution plan.

    Can somebody explain, what does the doc mean by saying objects cached ?

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Re: V$db_object_cache

    Originally posted by bang_dba
    Hi,

    V$DB_OBJECT_CACHE
    Documentation says this view displays objects that are cached in library cache. Objects include table,indexes etc

    As far as i know, in library cache, we have only the text code, parsed code and execution plan.

    Can somebody explain, what does the doc mean by saying objects cached ?
    You sure are confused chap...

    Tables, indexes etc are not objects they are segments

    Packages, Procedures, views, sequences are objects....
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Sep 2002
    Posts
    376

    Re: Re: V$db_object_cache

    Originally posted by adewri
    You sure are confused chap...

    Tables, indexes etc are not objects they are segments

    Packages, Procedures, views, sequences are objects....

    http://download-west.oracle.com/docs...ch339.htm#5236

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    The view V$DB_OBJECT_CACHE shows objects which are kept using the package DBMS_SHARED_POOL.KEEP only and its not possible to KEEP tables using DBMS_SHARED_POOL package.

    Use the storage clause "storage (BUFFER_POOL DEFAULT|KEEP|RECYCLE)" to pin tables.

    Also the view V$DB_OBJECT_CACHE doesnot show the pinned tables.
    check the views v$buffer_pool_statistics and v$buffer_pool to view statistics of pinned tables.

    HTH
    Last edited by adewri; 05-14-2003 at 07:24 AM.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  5. #5
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Could it be that table meta-data is cached here ?

  6. #6
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by DaPi
    Could it be that table meta-data is cached here ?
    Im not sure about that part. Keep column always shows NO in V$DB_OBJECT_CACHE, where as for a procedure it will show YES once its pinned using DBMS_SHARED_POOL.KEEP.

    However the column "type" does shows as "TABLE" when the table is pinned using storage clause (BUFFER_POOL KEEP). If its not pinned then it shows "NOT LOADED"
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  7. #7
    Join Date
    Sep 2002
    Posts
    376
    Originally posted by DaPi
    Could it be that table meta-data is cached here ?
    Table metadata is stored in the dictionary cache

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