Ok, another volley.
I have the same objects and conditions as described below (default block size 8k and
one 16k tablespace with one table).
The 16k table is small ( create table blah (col1 varchar2(10), col2 number) tablespace
my16ktbsp storage(buffer_pool KEEP);)
-- insert data
begin
for i in 1
John,
My earlier assumptions were wrong (usually are, that's why I test).
I set up a 9.2 instance with these parameters:
db_cache_size=300M
db_keep_cache_size=40M
db_16k_cache_size=40M
db_block_size=8192
Then, I created a tablespace MY16KTBSP with a 16k block size.
Then, create table TESTA tables
Hi John,
If I'm understanding what I'm reading from the 9i Concepts Guide, I think that
non-default block size objects can only go into the cache with the same block size
(meaning it can't go into keep buffer). I'm making this assumption because we can't
create a tablespace of 16k blocksize un
Title: RE: Question about buffer cache
I have indexes in a 16k page size tablespace.
I have the following init.ora parameters:
db_block_size=4096
db_cache_size=600M
db_keep_cache_size=200M
db_16k_cache_size=200M
If I alter an index to put it in the keep pool, how does Oracle hande the