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

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

db_name                         = RAB1
global_names                    = FALSE # Set to FALSE for DESIGNER/2000
db_domain                       = akadia.ch
compatible                      = 8.0.4.0.0
control_files                   = E:\Oradata\RAB1\ctl\RAB1_con01.con,
                                  E:\Oradata\RAB1\ctl\RAB1_con02.con,
                                  E:\Oradata\RAB1\ctl\RAB1_con03.con
control_file_record_keep_time   = 7

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

db_block_buffers                = 4000
# buffer_pool_keep              = (buffers:1500,lru_latches:1)
# buffer_pool_recycle           = (buffers:1000,lru_latches:1)
db_block_size                   = 4096
db_files                        = 25
db_file_multiblock_read_count   = 16

### 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\RAB1\arc
log_archive_format              = "ARC_%S.arc"
log_archive_duplex_dest         = E:\Oradata\RAB1\Dpx
log_archive_min_succeed_dest    = 2

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

shared_pool_size                = 15000000
shared_pool_reserved_size       =  200000
shared_pool_reserved_min_alloc  =  5000

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

processes                       = 40
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             = 2
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         = '.,'

### 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\RAB1\Adm\utld

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

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