Oracle参数优化实例

服务器 2CPU 4G内存
SGA
共享池   384M
缓冲区高速缓存   1008M
大型池 64M
Java池   32M
SGA总容量   1489.209M
SGA的最大大小   1521.471M

PGA
总计PGA目标800M

参数

control_files = ('/oracle/app/product/9.2.0/oradata/ora9/control01.ctl', '/oracle/app/product/9.2.0/oradata/ora9/control02.ctl', '/oracle/app/product/9.2.0/oradata/ora9/control03.ctl')
core_dump_dest = /oracle/app/product/9.2.0/admin/ora9/cdump
db_block_size = 8192
db_cache_size = 1056964608
db_domain = ''
db_file_multiblock_read_count = 16
db_name = ora9
dispatchers = '(PROTOCOL=TCP) (SERVICE=ora9XDB)'
fast_start_mttr_target = 300
hash_join_enabled = TRUE
instance_name = ora9
java_pool_size = 33554432
job_queue_processes = 10
large_pool_size = 67108864
log_archive_dest_1 = 'LOCATION=/oracle/app/product/9.2.0/dbs/arch'
open_cursors = 300
pga_aggregate_target = 838860800
processes = 300
query_rewrite_enabled = FALSE
remote_login_passwordfile = EXCLUSIVE
shared_pool_size = 402653184
sort_area_size = 524288
star_transformation_enabled = FALSE
timed_statistics = TRUE
undo_management = AUTO
undo_retention = 10800
undo_tablespace = UNDOTBS1
user_dump_dest = /oracle/app/product/9.2.0/admin/ora9/udump