|
db_name = ORA8
instance_name = ORA8
service_names = ORA8
control_files = ("/home2/oradata/ORA8/control01.ctl", "/home2/oradata/ORA8/contr
ol02.ctl")
db_files = 200
#db_block_buffers = 8192
db_block_buffers = 10000
##########################################
# 03-mar-2004 by han
##########################################
shared_pool_size = 52428800
shared_pool_reserved_size = 15728640
db_block_lru_latches = 12
log_checkpoint_interval = 50000
#shared_pool_size = 125829120
sort_area_size = 31457280
sort_area_retained_size = 15728640
java_pool_size = 20971520
#log_checkpoint_interval = 999999999
#log_checkpoint_timeout = 1800
processes = 200
log_buffer = 163840
audit_trail = OS
# 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=/oracle/app/oracle/admin/ORCL/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, r05, r06, r07, r08)
# 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
# define directories to store trace and alert files
background_dump_dest = /oracle/app/oracle/admin/ORA8/bdump
core_dump_dest = /oracle/app/oracle/admin/ORA8/cdump
user_dump_dest = /oracle/app/oracle/admin/ORA8/udump
#db_block_size = 2048
#remote_login_passwordfile = exclusive
#remote_login_passwordfile = shared
#os_authent_prefix = ""
# The following parameters are needed for the Advanced Replication Option
#job_queue_processes = 0
#job_queue_interval = 60
#distributed_transactions = 10
#open_links = 4
mts_dispatchers = "(PROTOCOL=TCP)(dispatchers=3)"
mts_max_dispatchers = 10
#mts_dispatchers = "(PROTOCOL=TCP)(PRE=203.235.139.222)"
# Uncomment the following line when your listener is configured for SSL
# (listener.ora and sqlnet.ora)
# mts_dispatchers = "(PROTOCOL=TCPS)(PRE=oracle.aurora.server.SGiopServer)"
mts_servers = 5
mts_max_servers = 10
compatible = "8.1.0"
####################################################
# disater recovery and parameter change
# by bongok.ha@oracle.com
# 14-sat-2000
####################################################
db_block_size = 8192
open_cursors = 500
###################################################
# 03-mar-2004 by han
###################################################
pre_page_sga = true
|