여기 부분에는 시스템 사양하고요 oracle init.ora파을 올리겠습니다.
보시고 확인좀 부탁드릴게요 제가 어떻게 해야 하는건지요..ㅜ.ㅜ
참고로 솔라리스 5cpu를 사용하고요 오라클은 8.0.5를 사용하고 db서버에
부하를 줄이게 위해서 mts 방법을 사용하고 있습니다...
o/s
System Configuration: Sun Microsystems sun4u 5-slot Sun Enterprise E3500
System clock frequency: 100 MHz
Memory size: 5120Mb
========================= CPUs =========================
Run Ecache CPU CPU
Brd CPU Module MHz MB Impl. Mask
--- --- ------- ----- ------ ------ ----
3 6 0 400 8.0 US-II 10.0
3 7 1 400 8.0 US-II 10.0
5 10 0 400 4.0 US-II 10.0
5 11 1 400 4.0 US-II 9.0
7 14 0 400 8.0 US-II 10.0
7 15 1 400 8.0 US-II 10.0
9 18 0 400 8.0 US-II 10.0
9 19 1 400 8.0 US-II 10.0
========================= Memory =========================
Intrlv. Intrlv.
Brd Bank MB Status Condition Speed Factor With
--- ----- ---- ------- ---------- ----- ------- -------
3 0 1024 Active OK 60ns 4-way A
3 1 1024 Active OK 60ns 1-way
5 0 1024 Active OK 60ns 4-way A
7 0 1024 Active OK 60ns 4-way A
9 0 1024 Active OK 60ns 4-way A
========================= IO Cards =========================
Bus Freq
Brd Type MHz Slot Name Model
--- ---- ---- ---- -------------------------------- ----------------------
1 SBus 25 0 SUNW,hme SUNW,501-2919
1 SBus 25 2 SUNW,hme SUNW,501-2919
1 SBus 25 3 SUNW,hme
1 SBus 25 3 SUNW,fas/sd (block)
1 SBus 25 13 SUNW,socal/sf (scsi-3) 501-3060
1 UPA 100 2 FFB, Double Buffered SUNW,501-4790
************************
db init.ora
************************
# SMALL MEDIUM LARGE
# Block 2K 4500K 6800K 17000K
# Size 4K 5500K 8800K 21000K
#
# To set up a database that multiple instances will be using, place
# all instance-specific parameters in one file, and then have all
# of these files point to a master file using the IFILE command.
# This way, when you change a public
# parameter, it will automatically change on all instances. This is
# necessary, since all instances must run with the same value for many
# parameters. For example, if you choose to use private rollback segments,
# these must be specified in different files, but since all gc_*
# parameters must be the same on all instances, they should be in one file.
#
# INSTRUCTIONS: Edit this file and the other INIT files it calls for
# your site, either by using the values provided here or by providing
# your own. Then place an IFILE= line into each instance-specific
# INIT file that points at this file.
###############################################################################
# tuning parameters
db_files = 80
#db_file_multiblock_read_count = 8 # SMALL
# db_file_multiblock_read_count = 16 # MEDIUM
db_file_multiblock_read_count = 32 # LARGE
#db_block_buffers = 200 # SMALL
# db_block_buffers = 550 # MEDIUM
# db_block_buffers = 3200 # LARGE
0b_block_buffers = 41214 # 2003_05_2
#shared_pool_size = 3500000 # SMALL
# shared_pool_size = 6000000 # MEDIUM
# shared_pool_size = 9000000 # LARGE
#shared_pool_size = 214748364 # LARGE
Ehared_pool_size = 824832142 # VERY LARG
#shared_pool_size = 1024832142 #2003_04_21
shared_pool_reserved_size = 400000000
1shared_pool_reserved_size = 500000000 #2003_04_2
_18en_cursors=200 #2003_04
_18g_simultaneous_copies=8 #2003_04
_18g_small_entry_max_size=400 #2003_04
_18_block_lru_latches=4 #2003_04
log_checkpoint_interval = 10000
#processes = 50 # SMALL
# processes = 100 # MEDIUM
#processes = 220 # LARGE
processes = 300 # VERY LARGE
#dml_locks = 100 # SMALL
# dml_locks = 200 # MEDIUM
# dml_locks = 500 # LARGE
dml_locks = 500 # LARGE
#log_buffer = 8192 # SMALL
# log_buffer = 32768 # MEDIUM
# log_buffer = 163840 # LARGE
log_buffer = 1048576 # LARGE
#sequence_cache_entries = 10 # SMALL
# sequence_cache_entries = 30 # MEDIUM
sequence_cache_entries = 100 # LARGE
#sequence_cache_hash_buckets = 10 # SMALL
# sequence_cache_hash_buckets = 23 # MEDIUM
sequence_cache_hash_buckets = 89 # LARGE
# audit_trail = true # if you want auditing
# timed_statistics = true # if you want timed statistics
max_dump_file_size = 10240 # limit trace file size to 5 Meg each
# log_archive_start = true # if you want automatic archiving
global_names = TRUE
#mts_dispatchers="tcp,10"
hers=1)"atchers="(address=(protocol=tcp)(port=48290)(host=150.23.15.68))(dispatc
hers=1)"atchers="(address=(protocol=tcp)(port=48292)(host=150.23.15.68))(dispatc
hers=1)"atchers="(address=(protocol=tcp)(port=48294)(host=150.23.15.68))(dispatc
hers=1)"atchers="(address=(protocol=tcp)(port=48296)(host=150.23.15.68))(dispatc
hers=1)"atchers="(address=(protocol=tcp)(port=48298)(host=150.23.15.68))(dispatc
hers=1)"atchers="(address=(protocol=tcp)(port=48280)(host=192.168.4.30))(dispatc
hers=1)"atchers="(address=(protocol=tcp)(port=48282)(host=192.168.4.30))(dispatc
hers=1)"atchers="(address=(protocol=tcp)(port=48284)(host=192.168.4.30))(dispatc
hers=1)"atchers="(address=(protocol=tcp)(port=48286)(host=192.168.4.30))(dispatc
hers=1)"atchers="(address=(protocol=tcp)(port=48288)(host=192.168.4.30))(dispatc
mts_max_dispatchers=20
mts_servers=6
mts_max_servers=60
mts_service=ORA8
|