initoradb.ora

一本介绍oracle的书籍

db_name = oradb
instance_name = oradb
service_names = oradb

control_files = ("/opt/oracle/oradata/oradb/control01.ctl", "/opt/oracle/oradata/oradb/control02.ctl")

db_block_size = 8192
db_block_buffers = 5000
shared_pool_size = 10000000

log_checkpoint_interval = 0
log_checkpoint_timeout = 0
log_buffer = 163840

processes = 200
sessions = 500
open_cursors = 500

sort_area_size = 10485760
sort_area_retained_size = 10485760

db_block_lru_latches = 4
db_writer_processes = 4

# audit_trail = false  # if you want auditing
# timed_statistics = false  # if you want timed statistics
# max_dump_file_size = 10000  # limit trace file size to 5M each

#log_archive_start = true
#log_archive_dest_1 = "location=/opt/oracle/admin/oradb/arch"
#log_archive_format = %t_%s.dbf
# If using private rollback segments, place lines of the following
# form in each of your instance-specific init.ora files:
#rollback_segments = (r01, r02, r03, r04)

# Global Naming -- enforce that a dblink has same name as the db it connects to
# global_names = false

# Uncomment the following line if you wish to enable the Oracle Trace product
# to trace server activity.  This enables scheduling of server collections
# from the Oracle Enterprise Manager Console.
# Also, if the oracle_trace_collection_name parameter is non-null,
# every session will write to the named collection, as well as enabling you
# to schedule future collections from the console.
# oracle_trace_enable = true

job_queue_processes = 4
job_queue_interval = 60

# define directories to store trace and alert files
background_dump_dest = /opt/oracle/admin/oradb/bdump
core_dump_dest = /opt/oracle/admin/oradb/cdump
user_dump_dest = /opt/oracle/admin/oradb/udump


remote_login_passwordfile = none

os_authent_prefix = ""

compatible = "8.1.0"