how to check table been "cache"?

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Mon, 1 Feb 2010 07:24:43 -0800 (PST)
Message-ID: <262225.14712.qm_at_web65713.mail.ac4.yahoo.com>

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 Received on Mon Feb 01 2010 - 09:24:43 CST