Sizing SGA
Dear All,
One of my main production db is running windows server 2000 and db version is 9.2.0.8 with 3 gb of ram server.Due to heavy load,The reponse time is very slow and on peak time it could not support more than 120 users.
Now i shifting the database to new server with windows server 2003,8 gb of ram.I must resize the sga component.
My current sga componets are like:
Shared Pool:304
Buffer Pool:152
Large Pool:8
Java pool:15
SGA Max:709
PGA_aggregate_target:450.
I m giving a look of my alert log showing parameter value:
System parameters with non-default values:
processes = 300
sessions = 335
timed_statistics = TRUE
resource_limit = FALSE
shared_pool_size = 318767104
sga_max_size = 744039096
large_pool_size = 8388608
java_pool_size = 159383552
enqueue_resources = 20968
nls_language = AMERICAN
nls_territory = AMERICA
db_block_size = 8192
db_cache_size = 159383552
db_cache_advice = ON
compatible = 9.2.0.0.0
remote_archive_enable = TRUE
log_archive_start = TRUE
log_archive_dest =
log_archive_dest_1 = LOCATION=d:\oracle\oradata\DTH\archive MANDATORY
log_archive_dest_2 = SERVICE=DTH OPTIONAL
log_archive_dest_3 = SERVICE=DTH OPTIONAL
log_archive_dest_state_2 = ENABLE
log_archive_dest_state_3 = ENABLE
log_archive_max_processes= 3
log_archive_format = %s.arc
log_buffer = 5242880
db_files = 100
db_file_multiblock_read_count= 16
standby_file_management = AUTO
dml_locks = 748
replication_dependency_tracking= TRUE
transactions = 350
undo_management = AUTO
undo_tablespace = UNDO
undo_retention = 7200
db_block_checking = true
remote_login_passwordfile= EXCLUSIVE
cursor_sharing = similar
parallel_min_servers = 0
parallel_max_servers = 5
open_cursors = 1500
optimizer_mode = all_rows
parallel_automatic_tuning= FALSE
optimizer_index_caching = 90
query_rewrite_enabled = true
pga_aggregate_target = 471859200
statistics_level = TYPICAL;
As i don't have much experience,I can't decide what value should i put for the SGA component.
Please Give some suggestion....
Thanks and Regards...