Oracle8 Server Migration
Release 8.0
A54650_01

Library

Product

Contents

Index

D
Oracle8 INIT.ORA Changes

Oracle8 provides some new INIT.ORA initialization parameters. Some Release 7.3 parameters have been changed or become obsolete in Oracle8. These parameters are discussed under the following topics:

Data Dictionary Protection

O7_DICTIONARY_ACCESSIBILITY is the INIT.ORA parameter switch that continues Oracle7 data dictionary behavior. It is only a temporary expedient, not planned for future Oracle8 releases.

DML_LOCKS

Oracle8 systems typically consume more DML locks while performing DDL operations than are required for Oracle7 systems. Nevertheless, the Oracle7 DML_LOCKS parameter default settings usually are adequate for Oracle8 systems, even for DML-intensive applications.

The default value of DML_LOCKS is a multiple of the number of transactions, which is calculated from the number of rollback segments. However, in Oracle8 fewer transactions are used per rollback segment than are used inOracle7. Consequently DML_LOCKS has a lower default value in Oracle8. Under some extreme test conditions, an Oracle8 system exceeded its (Oracle7) DML lock limit, and the DML_LOCKS parameter value had to be increased for those particular test conditions.

Relatedly, the TRANSACTION_PER_ROLLBACK_SEGMENT parameter setting might need adjustment, depending on the platform-specific settings. An informational message directing such change might be displayed during database startup operations, for example at Step 10 in "Migration on the Oracle8 Side" on page 3-10.

NCHAR and NLS Parameters and Compatibility

You should set NLS_LANG to your environment:

set ORA_NLS32 for 7.3.x environment
set ORA_NLS33 for 8.0 environment

Verify that the client side has the correct NLS character set environment variables.

An error is generated when Oracle 7.3 NLS code tries to load an Oracle8 character set.

Pre-Oracle8 Parameters Renamed in Release 8.0.3

The following initialization parameters have been renamed in Release 8.0.3:

Pre-Oracle8 Name	Release 8.0.3 Name
SNAPSHOT_REFRESH_INTERVAL	JOB_QUEUE_INTERVAL
SNAPSHOT_REFRESH_PROCESS	JOB_QUEUE_PROCESSES

Release 7.3 Parameters Obsolete in Release 8.0.3

INIT_SQL_FILES

LM_DOMAINS

LM_NON_FAULT_TOLERANT

PARALLEL_DEFAUILT_MAX_SCANS

PARALLEL_DEFAULT_SCANSIZE

SEQUENCE_CACHE_HASH_BUCKETS

SERIALIZABLE

SESSION_CACHED_CURSORS

REPLICATION_DEPENDENCY_TRACKING for the Replication Server

The REPLICATION_DEPENDENCY_TRACKING parameter is for turning DSCN tracking on or off, as follows.

TRUE (default value) turns dependency tracking ON for read/write operations to the database. Dependency tracking is essential for the Replication Server to propagate changes in parallel.

FALSE turns dependency tracking OFF. This condition allows read/write operations to the database to run faster, but it does not produce dependency information for the Replication server to perform parallel propagations.

Attention: Do not set REPLICATION_DEPENDENCY_TRACKING=FALSE if the application performs a read/write operation to any replicated table.

Features No Longer Supported in Release 8.0.3

This section identifies features associated with INIT.ORA file parameters from previous Oracle versions/releases that are being rendered obsolete by Oracle8 improvements. Oracle support for these items will likely be dropped in future releases, and they should thus be considered desupported in Release 8.0.3.

SERIALIZABLE=TRUE or _SERIALIZABLE

The INIT.ORA file parameter SERIALIZABLE=TRUE or _SERIALIZABLE implies automatic table-level locking ON READ in Release 8.0.3. It should not be used in any Oracle8 installation and will probably be permanently deleted from the maintenance release after 8.1.