Is my 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?
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...
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
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?
You do have a keep buffer pool, don't you?