大家好,我的数据库是 Solaris系统下的64位9i,内存10G,8cpu
下面是我的init参数配置,请大家给个建议,现在很慢,找不到具体原因,看能否优化一下,这是spfile的内容,谢谢了
aq_tm_processes = 1
background_dump_dest = /ora9i/admin/sysdb/bdump
compatible = 9.2.0.0.0
control_files = ('/data/oradata/sysdb/control01.ctl', '/data/oradata/sysdb/control02.ctl', '/data/oradata/sysdb/control03.ctl')
core_dump_dest = /ora9i/admin/sysdb/cdump
db_block_size = 8192
db_cache_size = 1056964608
db_domain = ''
db_file_multiblock_read_count = 16
db_name = sysdb
dispatchers = '(PROTOCOL=TCP) (SERVICE=sysdbXDB)'
fast_start_mttr_target = 300
hash_join_enabled = TRUE
instance_name = sysdb
java_pool_size = 117440512
job_queue_processes = 10
large_pool_size = 419430400
log_archive_dest_1 = 'LOCATION=/arch/sysdb/archive'
log_archive_format = '%t_%s.dbf'
log_archive_start = TRUE
open_cursors = 2000
pga_aggregate_target = 2097152000
processes = 1200
query_rewrite_enabled = FALSE
remote_login_passwordfile = EXCLUSIVE
sga_max_size = 4817133576
shared_pool_size = 3154116608
sort_area_size = 1048576
star_transformation_enabled = FALSE
timed_statistics = TRUE
undo_management = AUTO
undo_retention = 10800
undo_tablespace = UNDOTBS1
user_dump_dest = /ora9i/admin/sysdb/udump
下面是我的init参数配置,请大家给个建议,现在很慢,找不到具体原因,看能否优化一下,这是spfile的内容,谢谢了
aq_tm_processes = 1
background_dump_dest = /ora9i/admin/sysdb/bdump
compatible = 9.2.0.0.0
control_files = ('/data/oradata/sysdb/control01.ctl', '/data/oradata/sysdb/control02.ctl', '/data/oradata/sysdb/control03.ctl')
core_dump_dest = /ora9i/admin/sysdb/cdump
db_block_size = 8192
db_cache_size = 1056964608
db_domain = ''
db_file_multiblock_read_count = 16
db_name = sysdb
dispatchers = '(PROTOCOL=TCP) (SERVICE=sysdbXDB)'
fast_start_mttr_target = 300
hash_join_enabled = TRUE
instance_name = sysdb
java_pool_size = 117440512
job_queue_processes = 10
large_pool_size = 419430400
log_archive_dest_1 = 'LOCATION=/arch/sysdb/archive'
log_archive_format = '%t_%s.dbf'
log_archive_start = TRUE
open_cursors = 2000
pga_aggregate_target = 2097152000
processes = 1200
query_rewrite_enabled = FALSE
remote_login_passwordfile = EXCLUSIVE
sga_max_size = 4817133576
shared_pool_size = 3154116608
sort_area_size = 1048576
star_transformation_enabled = FALSE
timed_statistics = TRUE
undo_management = AUTO
undo_retention = 10800
undo_tablespace = UNDOTBS1
user_dump_dest = /ora9i/admin/sysdb/udump
太大了
给800M就可以了
db_cache_size = 1056964608
这个参数可以加大到5G
其他基本上可以不改
另外,慢是什么慢?是执行SQL脚本慢吗?如果是,还要找找应用端的SQL是否优化,
或者未建立索引等等
我认为,出了问题,首先是要识别这个问题在哪里,然后才是针对的解决。先做个statspack,然后如果怀疑那个业务执行有问题,就用autotrace跟踪一下。
这样会很慢很慢
你可以修改initsid.ora里的对应参数,然后重新启动数据库