操作系统:AIX 5.3 ORACLE:9.2.0.7 内存 6G 数据上建了8个用户,分别连接8个weblogic服务,以下是数据库的参数设置,哪位大虾帮我看看数据库的参数设置是否合理? 大概150个连接数background_dump_dest = /orapp/admin/lbn/bdump
cluster_database = TRUE
cluster_database_instances = 2
cluster_interconnects = 172.16.10.3
compatible = 9.2.0.0.0
control_files = ('/dev/rctl1_110m', '/dev/rctl2_110m', '/dev/rctl3_110m')
core_dump_dest = /orapp/admin/lbn/cdump
cpu_count = 4
db_block_size = 8192
db_cache_size = 1073741824
db_domain = ''
db_file_multiblock_read_count = 16
db_name = lbn
dispatchers = '(PROTOCOL=TCP) (SERVICE=lbnXDB)'
fast_start_mttr_target = 300
hash_join_enabled = TRUE
instance_name = lbn1
instance_number = 1
java_pool_size = 318767104
job_queue_processes = 10
large_pool_size = 318767104
local_listener = 'LISTENER_LBN1'
log_archive_dest_1 = 'LOCATION=/ARCH'
log_archive_format = '%t_%s.dbf'
log_archive_start = TRUE
open_cursors = 10000
pga_aggregate_target = 524288000
processes = 1024
query_rewrite_enabled = FALSE
remote_listener = LISTENERS_LBN
remote_login_passwordfile = EXCLUSIVE
service_names = LBN
sessions = 1131
shared_pool_size = 536870912
sort_area_size = 524288
spfile = /dev/rspf_5m
star_transformation_enabled = FALSE
thread = 1
timed_statistics = TRUE
undo_management = AUTO
undo_retention = 10800
undo_tablespace = UNDOTBS1
user_dump_dest = /orapp/admin/lbn/udump
utl_file_dir = /home/oracle/logmnr
cluster_database = TRUE
cluster_database_instances = 2
cluster_interconnects = 172.16.10.3
compatible = 9.2.0.0.0
control_files = ('/dev/rctl1_110m', '/dev/rctl2_110m', '/dev/rctl3_110m')
core_dump_dest = /orapp/admin/lbn/cdump
cpu_count = 4
db_block_size = 8192
db_cache_size = 1073741824
db_domain = ''
db_file_multiblock_read_count = 16
db_name = lbn
dispatchers = '(PROTOCOL=TCP) (SERVICE=lbnXDB)'
fast_start_mttr_target = 300
hash_join_enabled = TRUE
instance_name = lbn1
instance_number = 1
java_pool_size = 318767104
job_queue_processes = 10
large_pool_size = 318767104
local_listener = 'LISTENER_LBN1'
log_archive_dest_1 = 'LOCATION=/ARCH'
log_archive_format = '%t_%s.dbf'
log_archive_start = TRUE
open_cursors = 10000
pga_aggregate_target = 524288000
processes = 1024
query_rewrite_enabled = FALSE
remote_listener = LISTENERS_LBN
remote_login_passwordfile = EXCLUSIVE
service_names = LBN
sessions = 1131
shared_pool_size = 536870912
sort_area_size = 524288
spfile = /dev/rspf_5m
star_transformation_enabled = FALSE
thread = 1
timed_statistics = TRUE
undo_management = AUTO
undo_retention = 10800
undo_tablespace = UNDOTBS1
user_dump_dest = /orapp/admin/lbn/udump
utl_file_dir = /home/oracle/logmnr
解决方案 »
- oracle存储过程创建表并复制数据?求助高手
- 如何在存储过程中执行某个带返回值的存储过程
- 哪位大侠知道数据库保存会话的文件在哪啊?
- 这个触发器那儿有错,编译时提示有编译错误.
- 请问不用递归如何用一条sql查询树节点的所有嫡系祖先或所有嫡系后代
- 调试问题
- Enterprise Mmanager Configuration Assistant配置,登陆OMS问题!在线等,谢谢
- Configuration Assistant
- 一个非常非常简单的问题?
- SQL*PLUS工作单(workSheet)的乱码问题
- 请教高手一个问题: 在trigger中使用sequence ,实现在进行insert操作时,表中的ID字段自动增加
- 小弟新手碰到的一个需求,使用merge into 写了个存储过程。请教高手是否该过程是否可以实现,或者有什么更好的方法。
2、db_buffer,shared_buffer 都可以加大,各扩大1倍还没问题呢
3、large_pool 和 java_pool可以缩小 (不知道你前台是什么开发的)