Problem solve
Get help with specific problems with your technologies, process and projects.
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?
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 last published in October 2005
Dig Deeper on Oracle database performance problems and tuning
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments