Setting the DB_cache_Sizes to be different values
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Setting the DB_cache_Sizes to be different values

  1. #1
    Join Date
    Mar 2003
    Posts
    2

    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;

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758

    Re: Setting the DB_cache_Sizes to be different values

    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.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi,

    ALTER SYSTEM SET DB_CACHE_SIZE = 20M SCOPE= MEMORY| BOTH| SPFILE;

    Limit is SGA_MAX_SIZE ( Shared_pool-size + all DB_CACHE-Sizes + log_buffer, large_pool-size )
    Orca

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width