-
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 ?
-
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."
-
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
-
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."
-
Could it be that table meta-data is cached here ?
-
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."
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|