$ORACLE_HOME/dbs/initSID.ora 
------------------------------------------------------------------------------
db_name=sptest2
db_domain = test.ad.jp
global_names = TRUE
instance_name = sptest2
service_names = sptest2.test.ad.jp

control_files = ("/home/SYSTEM/control01.ctl", "/udb1/SYSTEM/control02.ctl", "/udb2/SYSTEM/control03.ctl")
rollback_segments = (RBS01,RBS02,RBS03,RBS04,RBS05,RBS06)
background_dump_dest = /home/SYSTEM/admin/bdump
core_dump_dest = /home/SYSTEM/admin/cdump
user_dump_dest = /home/SYSTEM/admin/udump
compatible = "8.1.6"
open_cursors = 100
max_enabled_roles = 30
max_rollback_segments = 1000

# db_block_buffers = 48000
db_block_buffers = 24000
db_block_size = 8192
db_files = 400
processes = 160

db_file_multiblock_read_count = 8

shared_pool_size = 20480000
large_pool_size = 50331648
java_pool_size = 0
log_buffer = 1024000
sort_area_size = 524288
sort_area_retained_size = 524288

# Net8 option
mts_dispatchers = "(ADDRESS=(PROTOCOL=TCP)(HOST=g32b21))(DISPATCHERS=2)"
mts_servers = 2
local_listener = "(ADDRESS_LIST=(ADDRESS=(PROTOCOL= TCP)(Host=g32b21)(Port= 1521))
(ADDRESS=(PROTOCOL= TCP)(Host=g32b21)(Port= 1522)))"
mts_max_servers=11

log_checkpoint_interval = 204801
log_checkpoint_timeout=0

# Replication Option
job_queue_processes = 4
job_queue_interval = 60
distributed_transactions = 10
open_links = 4


トップ   一覧 単語検索 最終更新   ヘルプ   最終更新のRSS