Приложение 2. Пример конфигурационного файла

Это пример INIT-файла для некоторого Объединения (INITORC1.ORA):

DB_NAME = NYORK

DB_FILES = 1020

CONTROL_FILES = ("VOL1:\ORANW804\DATAPLIS\ctl1orc1.ora",

                 "VOL1:\ORANW804\DATAPLIS\ctl2orc1.ora")

#COMPATIBLE= 7.3.2.0.0

#COMPATIBLE= 8.0.3.0.6

COMPATIBLE  = 8.0.4.2.0

DB_FILE_MULTIBLOCK_READ_COUNT = 16   # MEDIUM

DB_BLOCK_BUFFERS = 550                     # LARGE

SHARED_POOL_SIZE = 20000000

SORT_AREA_SIZE = 512000

#CHECKPOINT_PROCESS= TRUE

#LOG_CHECKPOINT_INTERVAL= 8000

#LOG_CHECKPOINT_TIMEOUT= 0

PROCESSES = 200                            # MEDIUM

DML_LOCKS = 300

LOG_BUFFER = 64000

SEQUENCE_CACHE_ENTRIES = 30         # MEDIUM

SEQUENCE_CACHE_HASH_BUCKETS = 23    # MEDIUM

OPEN_CURSORS = 250

TIMED_STATISTICS = TRUE              # для сбора статистики

#SESSIONS= 115

#AUDIT_TRAIL = TRUE                  # if you want auditing

#TIMED_STATISTICS = TRUE             # if you want timed statistics

MAX_DUMP_FILE_SIZE = 10240      # limit trace file size to 5 M each

LOG_ARCHIVE_START = TRUE   # if you want automatic archiving

LOG_ARCHIVE_DEST = VOL1:\ORANW804\DATAPLIS\ARCHIVE   # if …

# Define directories to store trace and alert files

BACKGROUND_DUMP_DEST = VOL1:\ORANW804\RDBMS80\TRACE

USER_DUMP_DEST = VOL1:\ORANW804\RDBMS80\TRACE

DB_BLOCK_SIZE = 8192

REMOTE_LOGIN_PASSWORDFILE = SHARED

#OS_AUTHENT_PREFIX = ""

# See release notes for the description of the event

#EVENT = " 10805 trace name context forever, level 1 "

###############   Oracle replication ########################

GLOBAL_NAMES = TRUE

JOB_QUEUE_PROCESSES = 4

JOB_QUEUE_INTERVAL = 3600

JOB_QUEUE_KEEP_CONNECTIONS = FALSE

DISTRIBUTED_LOCK_TIMEOUT = 300

DISTRIBUTED_TRANSACTIONS = 5

OPEN_LINKS = 10

SNAPSHOT_REFRESH_INTERVAL = 60

SNAPSHOT_REFRESH_KEEP_CONNECTIONS = FALSE

SNAPSHOT_REFRESH_PROCESSES = 2

PARALLEL_MAX_SERVERS = 10

PARALLEL_MIN_SERVERS = 2

REPLICATION_DEPENDENCY_TRACKING = TRUE