Table won't come in cache. You have to select rows
from the table to get it into
cache. Another point is that
kept field is meant for pl/sql packages and functions and not for objects
like tables/indexes etc. Below is full details of objects and their codes that can be kept on database
startup.
--
Value Kind of Object to
keep --
-----
---------------------- --
P
package/procedure/function --
Q sequence
--
R trigger
--
T type
-- JS
java source
-- JC
java class --
JR java resource
--
JD java shared data
--
C
cursor
So just run the command , select * from xxx ;
and select * from yyy, and finally
check after long
time to verify that only xxx is in cache and yyy is flushed out
from
cache.
Of
course for verifying you can use,
select name, owner from
v$db_object_cache where name in ( 'xxx', 'yyy') ;
HTH,
Rajesh
-----Original
Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Bunyamin K. Karadeniz Sent: Saturday, September 29,
2001 10:55 PM To: Multiple recipients of list
ORACLE-L Subject: cached tables
I execute
alter table xxx cache ;
But can not see this cached table on the query
below. Why ? Do you have any idea.?