initoradb.ora

一本介绍oracle的书籍

db_name = oradb
instance_name = oradb
control_files = ('/opt/oracle/oradata/oradb/ora_control1.ctl', '/opt/oracle/oradata/oradb/ora_control2.ctl')

db_block_size = 8192

pga_aggregate_target = 50M
db_cache_size = 100M
shared_pool_size = 50M

processes = 200
sessions = 500
open_cursors = 500
db_writer_processes = 2

db_file_multiblock_read_count = 16

log_checkpoint_interval = 0
log_checkpoint_timeout = 0
log_buffer = 524288
log_archive_start = true
log_archive_dest_1 = "location=/opt/oracle/oradata/oradb/arch"
log_archive_format = %T_%S.dbf

background_dump_dest = /opt/oracle/admin/oradb/bdump
core_dump_dest = /opt/oracle/admin/oradb/cdump
user_dump_dest = /opt/oracle/admin/oradb/udump

undo_management = auto
undo_tablespace = tbsundo

parallel_automatic_tuning = true
#parallel_threads_per_cpu = 2

compatible = 9.0.0
optimizer_features_enable = 9.0.0

#db_domain = 
#remote_login_passwordfile = exclusive