Initialization File for Original Production Database
#==================================================================+
# FILENAME initdbase.ora
# DESCRIPTION Oracle parameter file for primary database, dbase.
#==================================================================
db_block_size = 8192
parallel_max_servers = 30
recovery_parallelism = 20
# db_writers = 25
# use_async_io = TRUE
# async_io = 1
control_files = (/dbase_vol/cntrl1)
sort_area_size = 15728640
parallel_max_servers = 10
recovery_parallelism = 4
compatible = 8.1.5
db_name = dbase
db_files = 200
db_file_multiblock_read_count = 32
db_block_buffers = 30720 # 8k * 30720 approx 250MB
dml_locks = 500
hash_join_enabled = FALSE
# Uncommenting the line below will cause automatic archiving if
# archiving has been enabled using ALTER DATABASE ARCHIVELOG.
log_archive_dest = /archlog
log_archive_format = dbase%t_%s.dbf
log_archive_start = TRUE
# log_checkpoint_interval = 1000000000
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 = /oracle/816/admin/dbase/bdump
core_dump_dest = /oracle/816/admin/dbase/cdump
user_dump_dest = /oracle/816/admin/dbase/udump
|
