1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56
|
control_files = (/home/ka/base_ka/control01.ctl,
/home/ka/base_ka/control02.ctl,
/home/ka/base_ka/control03.ctl)
background_dump_dest = /home/ka/base_ka/bdump
core_dump_dest = /home/ka/base_ka/cdump
user_dump_dest = /home/ka/base_ka/udump
#log_archive_dest = /home/appli/harpege9/harprod9/arch/arch.log
#db_block_size = <blocksize>
db_name = ka
db_domain = .WORLD
service_names ="ka.WORLD"
rollback_segments = (r01,r02,r03,r04,r05,r06,r07,r08,r09,r10,r11,r12)
# tuning parameters
db_files = 20
db_file_multiblock_read_count = 8
db_block_buffers = 2500
shared_pool_size = 30000000
log_checkpoint_interval = 10000
processes = 70
enqueue_resources = 105
log_buffer = 32768
open_cursors = 500
#sequence_cache_entries = 10
#sequence_cache_hash_buckets = 10
max_dump_file_size = 10240 # limit trace file size to 5 Meg each
max_enabled_roles = 48
sort_area_size = 131072
optimizer_mode = RULE
compatible = 9.2.0.0.0 |
Partager