Setting the DB_cache_Sizes to be different values
I want to be able to set 4 different DB_CACHE_SIZEs. Then for each of the create a tablespace on each of them. Then a table on each of the tablespaces and eventually insert some data into the tables so I can perform a collection.
I know I am able to achieve the results below however am I able to change each of the DB_CACHE_Sizes on one Oracle database instance. I was thinking about 9.i and or 9.2?
DB_CACHE_SIZE=8M
DB_2K_CACHE_SIZE = 8M
DB_4K_CACHE_SIZE = 8M
DB_16K_CACHE_SIZE = 8M
CREATE TABLESPACE eight_k;
CREATE TABLESPACE two_k BLOCKSIZE 2048;
CREATE TABLESPACE four_k BLOCKSIZE 4096;
CREATE TABLESPACE sixteen_k BLOCKSIZE 16384;
CREATE TABLE eight (id NUMBER(10)) TABLESPACE eight_k;
CREATE TABLE two (id NUMBER(10)) TABLESPACE two_k;
CREATE TABLE four (id NUMBER(10)) TABLESPACE four_k;
CREATE TABLE sixteen (id NUMBER(10)) TABLESPACE sixteen_k;
Re: Setting the DB_cache_Sizes to be different values
Quote:
Originally posted by speedy77
I know I am able to achieve the results below however am I able to change each of the DB_CACHE_Sizes on one Oracle database instance. I was thinking about 9.i and or 9.2?
yes, you can. You can change it dynamically as well.