change db_cache_size [message #608217] |
Mon, 17 February 2014 11:15 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/c953db5c6dbd95b304a73d448e50c7e8?s=64&d=mm&r=g) |
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..
|
|
|
|
|
|
|
|
|
|
|