Parameters New in Oracle8

Following is a list of parameters that are new for Oracle8. These parameters must not appear in the INIT.ORA file for an Oracle7 database. We’ve noted the parameters that have replaced equivalent Oracle7 parameters.

ALLOW_PARTIAL_SN_RESULTS

AQ_TM_PROCESSES

ARCH_IO_SLAVES

BACKUP_DISK_IO_SLAVES

BACKUP_TAPE_IO_SLAVES

COMPLEX_VIEW_MERGING

CONTROL_FILE_RECORD_KEEP_TIME

DB_BLOCK_MAX_DIRTY_TARGET

DB_FILE_DIRECT_IO_COUNT

DB_FILE_NAME_CONVERT (replaces DB_FILE_STANDBY_NAME_CONVERT)

DBWR_IO_SLAVES (replaces DB_WRITERS)

DISK_ASYNCH_IO

FAST_FULL_SCAN_ENABLED

FREEZE_DB_FOR_FAST_INSTANCE_RECOVERY

GC_DEFER_TIME

HASH_JOIN_ENABLED

INSTANCE_GROUPS

JOB_QUEUE_INTERVAL (replaces SNAPSHOT_REFRESH_INTERVAL)

JOB_QUEUE_PROCESSES (replaces SNAPSHOT_REFRESH_PROCESS)

LARGE_POOL_MIN_ALLOC

LARGE_POOL_SIZE

LGWR_IO_SLAVES

LM_LOCKS

LM_PROCS

LM_RESS

LOCAL_LISTENER

LOCK_NAME_SPACE

LOG_ARCHIVE_DUPLEX_DEST

LOG_ARCHIVE_MIN_SUCCEED_DEST

LOG_FILE_NAME_CONVERT

MTS_RATE_LOG_SIZE

MTS_RATE_SCALE

O7_DICTIONARY_ACCESSIBILITY

OBJECT_CACHE_MAX_SIZE_PERCENT

OBJECT_CACHE_OPTIMAL_SIZE

OPEN_LINKS_PER_INSTANCE

OPS_ADMIN_GROUP

OPTIMIZER_FEATURES_ENABLE

PARALLEL_INSTANCE_GROUP

PARALLEL_MIN_MESSAGE_POOL

PARALLEL_SERVER

PARALLEL_TRANSACTION_RESOURCE_TIMEOUT

PLSQL_V2_COMPATIBILITY

PUSH_JOIN_PREDICATE

REPLICATION_DEPENDENCY_TRACKING

SERIAL_REUSE

SESSION_MAX_OPEN_FILES

STAR_TRANSFORMATION_ENABLED

TAPE_ASYNCH_IO

TIMED_OS_STATISTICS

TRANSACTION_AUDITING

USE_ISM ...

Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.