有关oracle参数配置

显示全部楼层 · 2005-6-21 01:01:50

我的系统是linux,oracle 9.2.05. 服务器安装成RAC,
硬件配置：内存：4G; 硬盘：8x72G+4x36G,分别做raid1。
应用数据占：40G磁盘空间。
以下是参数文件：请问参数配置是否合理，谢谢！！
rem
aq_tm_processes = 1
background_dump_dest = /opt/oracle/admin/lnora/bdump
cluster_database = TRUE
cluster_database_instances = 2
compatible = 9.2.0.0.0
control_files = "/hisdb/main/lnora/control02.ctl"
control_files = "/hisdb/main/lnora/control01.ctl"
control_files = "/hisdb/index/lnora/control03.ctl"
core_dump_dest = /opt/oracle/admin/lnora/cdump
db_block_size = 8192
db_cache_size = 1342177280
db_domain =
db_file_multiblock_read_count = 32
db_name = lnora
dispatchers = (PROTOCOL=TCP) (SERVICE=lnoraXDB)
fast_start_mttr_target = 300
hash_join_enabled = TRUE
instance_name = lnora2
instance_number = 2
java_pool_size = 33554432
job_queue_processes = 10
large_pool_size = 67108864
local_listener = "LISTENER_LNORA2"
log_archive_dest_1 = "LOCATION=/hisdb/archlog/lnora"
log_archive_format = "arch_%t_%s.log"
log_archive_start = FALSE
open_cursors = 300
pga_aggregate_target = 434110464
processes = 800
query_rewrite_enabled = FALSE
remote_listener = LISTENERS_LNORA
remote_login_passwordfile = EXCLUSIVE
shared_pool_size = 167772160
sort_area_size = 1048576
spfile = /hisdb/main/lnora/spfilelnora.ora
star_transformation_enabled = FALSE
thread = 2
timed_statistics = TRUE
undo_management = AUTO
undo_retention = 10800
undo_tablespace = UNDOTBS2
user_dump_dest = /opt/oracle/admin/lnora/udump
rem

千问 · 2005-6-21 01:01:50

你的硬件配置是什么样子的萨

千问 · 2005-6-21 01:01:50

参数配置和应用有很大关系。楼主得简单介绍一下。还有硬件配置。

千问 · 2005-6-21 01:01:50

job_queue_processes = 10
好像9I的最大值是1000，不知道到了之后，如何使系统的作业号降下来，借贵地问问，各位有人知道吗？

千问 · 2005-6-21 01:01:50

硬件配置及所占空间已补上，恳请各位感兴趣的人士赐教！！

千问 · 2005-6-21 01:01:50

好像没有什么大的问题。

千问 · 2005-6-21 01:01:50

没有啥问题
还可以