Database Administration (MOSC)

MOSC Banner

Plz explain about wrong size of database buffer cache ?

edited Mar 16, 2012 5:30AM in Database Administration (MOSC) 3 commentsAnswered ✓
   Hi all,
    I have been used oracle version 9.2.0.4 32 bit.

    I want change size of database buffer cache, I use:

    SQL> show parameter sga_;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sga_max_size                         big integer 269554828

   SQL> alter system set db_cache_size=40M;

   System altered.

   I checked again:

   SQL> show parameter db_cache_size;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_cache_size                        big integer 50331648    --> why it about 48 MB ?? (I set 40 MB) ??

    And after that, I were set DB_KEEP_CACHE_SIZE is 10MB with SQL> alter system set db_keep_cache_size=10M;

    But when I checked again:

    SQL> show parameter db_keep_cache;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center