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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
