Q

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 first published in October 2005

Dig deeper on Oracle database performance problems and tuning

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close