Is my table in the buffer pool keep?
This is regarding keeping a table in the buffer pool keep. I created a
table using the command 'create table t (no number)' followed by an alter,
'alter table t storage(buffer_pool keep).'
There are 100 rows in this table. If I query v$db_object_cache, I do not
find this table as kept. However if I query user_segments, I find this
table as kept.
Is this table in the buffer pool keep? If yes, why am I not able to find the record in v$db_object_cache?
User_segments will show the table as "keep" because you defined it that way. However, a table defined as "keep" is not guaranteed to stay in memory, depending on the size of the keep buffer pool and how many objects use it.
You do have a keep buffer pool, don't you?
This was first published in October 2005