- 论坛徽章:
- 0
|
CICS与ORACLE连接问题!
init.ora
compatible = "8.1.0"
db_name = sfhc
instance_name = sfhc
service_names = sfhc
control_files = ("/soft/oracle/oradata/OraCtl1.ctl","/soft/oracle/oradata/OraCtl2.ctl","/soft/oracle/oradata/OraCtl3.ctl"
db_files = 1000
db_block_size = 8192
db_file_multiblock_read_count =8 #2003/7/16 modify by tjg
db_block_buffers = 204800
shared_pool_size = 524288000
shared_pool_reserved_size = 125829120
processes = 1500
sessions =1000
log_buffer = 1048576
rollback_segments=(r01,r02,r03,r04)
background_dump_dest = /soft/oracle/admin/sfhc/bdump
core_dump_dest = /soft/oracle/admin/sfhc/cdump
user_dump_dest = /soft/oracle/admin/sfhc/udump
remote_login_passwordfile = exclusive
os_authent_prefix = ""
pre_page_sga = yes
optimizer_features_enable = 8.1.5
optimizer_mode = choose
optimizer_percent_parallel = 50
optimizer_index_caching = 30
disk_asynch_io = true
tape_asynch_io = true
large_pool_size = 52428800 #2003/12/08 add by tzg
resource_limit = true
gc_releasable_locks = 89600 #db_block_buffers
enqueue_resources = 6000
open_cursors = 300
session_cached_cursors = 30
sort_area_size = 4194304
sort_area_retained_size = 1048576
sort_multiblock_read_count = 8
hash_join_enabled = true
hash_area_size = 16777216
hash_multiblock_io_count = 8
bitmap_merge_area_size = 4194304
create_bitmap_area_size = 12582912
star_transformation_enabled = true
query_rewrite_enabled = true
_push_join_predicate = true
log_checkpoint_interval = 9999999
log_checkpoint_timeout = 0
log_checkpoints_to_alert = true
log_archive_start = true
log_archive_dest_1 = "location=/oracle_arch reopen=10"
log_archive_format = %t_%s.dbf
nls_language = "simplified chinese"
nls_territory = "china"
nls_date_format = "YYYY-MM-DD"
job_queue_processes=1
job_queue_interval=60 |
|