Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

diff btwn alter table name ( buffer_pool keep) & alter table name cache????

65484May 17 2007 — edited Aug 6 2007

Hi
I want to keep few smal tables permanently in cache.....

whats the difference and which is better

option 1
alter table name storage ( buffer_pool keep)

option 1
alter table name cache

Regards
Gagan

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 3 2007

Added on May 17 2007

#general-database-discussions

4 comments

676 views