OraFAQ Forum: Server Administration » change db_cache

Home » RDBMS Server » Server Administration » change db_cache_size (oracle 11gR2 on 64bit windows 2008 r2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

change db_cache_size [message #608217]

Mon, 17 February 2014 11:15

krish96
Messages: 74
Registered: October 2012

Member

Hello Friends,

How to change the db_cache_size on 11g r2 / windows to 2600MB

Here is the current parameters of SGA
SQL> show sga

Total System Global Area 4275781632 bytes
Fixed Size 2262048 bytes
Variable Size 3372223456 bytes
Database Buffers 889192448 bytes
Redo Buffers 12103680 bytes
SQL>

SQL> show parameter max

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size integer 0
license_max_sessions integer 0
license_max_users integer 0
log_archive_max_processes integer 4
max_dispatchers integer
max_dump_file_size string unlimited
max_enabled_roles integer 150
max_shared_servers integer
memory_max_target big integer 4G
object_cache_max_size_percent integer 10
parallel_max_servers integer 0

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
result_cache_max_result integer 5
result_cache_max_size big integer 12640K
sec_max_failed_login_attempts integer 10
session_max_open_files integer 10
sga_max_size big integer 4G
SQL>

Please guide me with your suggestions ..
thanks in advance.

Krish..

Report message to a moderator

Re: change db_cache_size [message #608218 is a reply to message #608217]

Mon, 17 February 2014 11:28

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Just remove the parameter as well as sga_max_size, sga_max_target.

Report message to a moderator

Re: change db_cache_size [message #608219 is a reply to message #608218]

Mon, 17 February 2014 11:40

krish96
Messages: 74
Registered: October 2012

Member

thanks michel, for the quick response..want me to remove these parameters and set the value to sga_max_size=0, sga_max_target=0 in the pfile and start the database..

Report message to a moderator

Re: change db_cache_size [message #608220 is a reply to message #608219]

Mon, 17 February 2014 11:52

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes.

Report message to a moderator

Re: change db_cache_size [message #608333 is a reply to message #608220]

Tue, 18 February 2014 15:24

krish96
Messages: 74
Registered: October 2012

Member

Hello Michel..

thanks for your response.. after changing the db_cache_size still the show parameter displays same old value .. can you please suggest me..

SQL> alter system set db_cache_size=2600M scope=spfile;

System altered.

SQL> show parameter target

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
db_flashback_retention_target integer 1440
fast_start_io_target integer 0
fast_start_mttr_target integer 0
memory_max_target big integer 4G
memory_target big integer 4G
parallel_servers_target integer 0
pga_aggregate_target big integer 819M
sga_target big integer 0
SQL> show parameter db_cache_size

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_cache_size big integer 0
SQL>

Report message to a moderator