fyko init.ora ÆÄÀÏ
ÀÛ¼ºÀÚ °ü¸®ÀÚ ÀÛ¼º½Ã°£ 2004-09-17 22:56:44
 

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


¸ñ·Ï | ÀÔ·Â | ¼öÁ¤ | ´äº¯ | »èÁ¦