how to check table been "cache"?

  • From: dba1 mcc <mccdba1@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 1 Feb 2010 07:24:43 -0800 (PST)

I have table want put on "cache".  I used following way to do:

alter table table1 cache;

select owner, name, type, kept from v$db_object_cache;

OWNER                NAME                                                       
  TYPE            KEP
-------------------- 
------------------------------------------------------------ --------------- ---
USER1               table1                                                NOT 
LOADED      NO


this table in "cache" but not "KEPT".

I used another way to do this:

alter table table1 storage (buffer_pool keep);

select owner, name, type, kept from v$db_object_cache;
no rows selected

Anyone know where is "cache"?

Thanks.




      

--
http://www.freelists.org/webpage/oracle-l


Other related posts: