# Akadia AG, Zieglerstrasse 34, CH-3007 Bern 
# ----------------------------------------------------------------------
#
# File:       initARK2.ora
#
# Autor:      Martin Zahn / 10.07.1998
# 
# Purpose:    Instance configuration parameters 
#
# Location:   $ORACLE_HOME\Database 
#
# Certified:  Oracle V.8.0.5 on Windows-NT
# ----------------------------------------------------------------------

### Global Naming
### -------------
# Enforce that a dblink has same name as the db it connects to

global_names                     = True
 
# Edit and uncomment the following line to provide the suffix that will be
# appended to the db_name parameter (separated with a dot) and stored as the
# global database name when a database is created.  If your site uses
# Internet Domain names for e-mail, then the part of your e-mail address after
# the '@' is a good candidate for this parameter value.
# db_domain = us.acme.com   # global database name is db_name.db_domain

db_name                          =  ARK2
db_domain                        =  world

### Basic Configuration Parameters
### ------------------------------

compatible                      = 8.0.5.0.0
control_file_record_keep_time   = 7
control_files                   = E:\Oradata\ARK2\ctl\ARK2_con01.con,
                                  E:\Oradata\ARK2\ctl\ARK2_con02.con,
                                  E:\Oradata\ARK2\ctl\ARK2_con03.con

### Database Buffer Cache, I/O
### --------------------------

db_block_buffers                = 2000
buffer_pool_keep                = (buffers:500,lru_latches:1)
buffer_pool_recycle             = (buffers:200,lru_latches:1)
db_block_lru_latches            = 6
db_block_size                   = 4096
db_files                        = 25
db_file_multiblock_read_count   = 32

### UNDO Logging 
### ------------

rollback_segments               = (RBS01,RBS02,RBS03,RBS04,RBS05,RBS06)

### Checkpointing
### -------------

log_checkpoint_timeout          = 0
log_checkpoint_interval         = 10000

### REDO Logging
### ------------

log_buffer                      = 163840
log_archive_start               = False
log_archive_dest                = E:\Oradata\ARK2\arc
log_archive_format              = "ARC_%S.arc"
log_archive_duplex_dest         = E:\Oradata\ARK2\Dpx
log_archive_min_succeed_dest    = 2

### Database Library Cache
### ----------------------

shared_pool_size                = 1500000
shared_pool_reserved_size       = 20000
shared_pool_reserved_min_alloc  = 5000

### SQL Processing, Optimizer, Sequences
### ------------------------------------

dml_locks                       = 500
sequence_cache_entries          = 100
sequence_cache_hash_buckets     = 89
open_cursors                    = 512
session_cached_cursors          = 10

### Sorting
### -------

sort_area_retained_size         = 131072        # From Oracle EXPERT
sort_area_size                  = 131072        # From Oracle EXPERT

### User Management-Parameter
### -------------------------

max_enabled_roles               = 100
os_authent_prefix               = OPS$
remote_os_authent               = False
max_enabled_roles               = 100

### DDB- und DBMS_JOB-Parameter
### ---------------------------

job_queue_interval              = 30
job_queue_keep_connections      = False
job_queue_processes             = 1
remote_login_passwordfile       = exclusive
dblink_encrypt_login            = True

### MTS-Configuration
### -----------------

# NT is already multithreaded, so we don't need the Oracle MTS option.
# If you configure it, Oracle simply ignores the mts parameters in the
# init.ora parameter file

### NLS-Parameter
### -------------

nls_date_format                = 'DD.MM.YYYY'
nls_numeric_characters         = '.,'
nls_language                   =  AMERICAN
nls_territory                  =  AMERICA


### Optimizer-Parameter
### -------------------

optimizer_mode                = choose
hash_join_enabled             = true
always_anti_join              = Hash
hash_area_size                = 265000   # 2 * SORT_AREA_SIZE
partition_view_enabled        = true

### PL/SQL File I/O
### ---------------

utl_file_dir                  = E:\Oradata\ARK2\Adm\utld

### Traces, Dumps & Statistics
### --------------------------

background_dump_dest          = E:\Oradata\ARK2\Adm\cdmp
user_dump_dest                = E:\Oradata\ARK2\Adm\bdmp
timed_statistics              = true
sql_trace                     = false
max_dump_file_size            = 10240

### Processes, Transactions, User Licensing, Locks
### ----------------------------------------------

processes                     =  20
license_max_sessions          =  0    # Licensing is not enforced
license_sessions_warning      =  0    # No warning when limit is reached
enqueue_resources             =  4096

### Parallel Query Option
### ---------------------

parallel_min_servers          =  2
parallel_max_servers          =  20
parallel_server_idle_time     =  5