setting db_cache_size when using automatic sga management
From: K R <kp0773_at_gmail.com>
Date: Sat, 19 Jun 2010 12:10:38 -0700
Message-ID: <AANLkTil8urf1Y7kT1GbjHnn8ha6fdGgrFQIvy_7TG_n6_at_mail.gmail.com>
All,
Date: Sat, 19 Jun 2010 12:10:38 -0700
Message-ID: <AANLkTil8urf1Y7kT1GbjHnn8ha6fdGgrFQIvy_7TG_n6_at_mail.gmail.com>
All,
**Here is my scenario on a Oracle 10.2.0.4 on solaris 10.
sga_max_size set at 6G
db_cache_size at 3G
sga_target -0 - disabled
and during certain time I observe the cache hit ratio goes to 60% . I am planning to enable ASMM as below
sga_max_size - 8G
db_cache_size -3G
sga_target - 6G
so will oracle extend the db_cache_size to maintain a better hit ratio ? will it work ?
but again anybody has any experience with this bug
which crashes the instance when we have ASMM enabled and then setting up
manually a db_cache_size .
*Ora-00600: [Kmgs_pre_process_request_2] after having adjusted db_cache_size
[ID 737458.1]
Appreciate any recommendation here
thanks in advance
Kart
*
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Jun 19 2010 - 14:10:38 CDT