Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help: 9i multi cache buffer

Help: 9i multi cache buffer

From: charlie cs <cs3526_at_ureach.com>
Date: Tue, 12 Nov 2002 01:57:42 GMT
Message-ID: <qeZz9.5609$6Z.5205@nwrddc01.gnilink.net>


I am kind of confused with 9i multi cache buffer concept. Say in my database,
I have set up:
Tablespace A: 2k block size,

                  B:    8k block size (default)
and I set
db_2K_cache_size = 20m
db_cache_keep = 20m

If I create a table in tablespace A,
then I alter table storage (buffer_pool keep), where will this table stay in memory?
db_2k_cache_size or
db_cache_keep?

Thanks for your help Received on Mon Nov 11 2002 - 19:57:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US