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!

Difference between 12c In-Memory option and 11g's BUFFER_POOL KEEP

pcpaascheOct 6 2013 — edited Oct 13 2013

Can anybody please enlighten me in a brief comment on the difference between the new In-Memory option of Oracle 12c and the existing functionality in Oracle 11g where you can store a table permanently in buffer cache by STORAGE (BUFFER_POOL KEEP) as shown in the code sample below?

I have searched the internet for an answer to this, but with no luck.

CREATE TABLE t1 (

my_date DATE NOT NULL,

my_number NUMBER(12,10) NOT NULL,

my_row NUMBER(12) NOT NULL)

STORAGE (BUFFER_POOL KEEP);

Source : Oracle Buffer Pool Keep Pool Recycle Pool

This post has been answered by Jonathan Lewis on Oct 6 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 10 2013

Added on Oct 6 2013

#general-database-discussions

4 comments

15,041 views