Initialization File for Replica Oracle Database
##==================================================================+
# FILENAME initREP1.ora
# DESCRIPTION Oracle parameter file for replica database, REP1.
#==================================================================
db_block_size = 8192
parallel_max_servers = 30
recovery_parallelism = 20
# db_writers = 25
# use_async_io = TRUE
# async_io = 1
control_files = (/rep/dbase_vol/cntrl1)
sort_area_size = 15728640
parallel_max_servers = 10
recovery_parallelism = 4
compatible = 8.1.5
db_name = REP1
db_files = 200
db_file_multiblock_read_count = 32
db_block_buffers = 10240
dml_locks = 500
hash_join_enabled = FALSE
log_archive_start = FALSE
log_archive_dest = /rep/archlog
log_archive_format = dbase%t_%s.dbf
log_checkpoint_timeout = 300
log_checkpoints_to_alert = TRUE
log_buffer = 1048576
max_rollback_segments = 220
processes = 300
sessions = 400
open_cursors = 200
transactions = 400
distributed_transactions = 0
transactions_per_rollback_segment = 1
rollback_segments = (s1,s2,s3,s4,s5,s6,s7,s8,s9,s10,s11,s12,s13,s14,s15,s16,s17,s18,s19,s20,s21,s22,s23,s24,s25,s26,s27,s28,s29,s30)
shared_pool_size = 7000000
cursor_space_for_time = TRUE
audit_trail = FALSE
cursor_space_for_time = TRUE
background_dump_dest = /rep/oracle/816/admin/REP1/bdump
core_dump_dest = /rep/oracle/816/admin/REP1/cdump
user_dump_dest = /rep/oracle/816/admin/REP1/udump
|
