Parallel Server Configuration
In order to utilize Oracle Parallel Server (OPS), which allows a single Oracle database to be shared by multiple Oracle instances, you must carefully specify the Parallel Server characteristics using INIT.ORA parameters on each participating instance, including:
- PARALLEL_SERVER
Must be set to TRUE to enable the Oracle Parallel Server (Oracle8 only).
- INSTANCE_NUMBER
Identifies the instance to the database.
- ROLLBACK_SEGMENTS
Specifies the private rollback segments to be used by each instance. Public rollback segments can also be specified, but this is not necessary.
- THREAD
Identifies the redo log thread to be associated with the instance.
- GC_DB_LOCKS
The total number of instance locks (Oracle7 only).
- GC_FILES_TO_LOCKS
The number of database file locks.
- GC_LCK_PROCS
The total number of distributed locks.
- GC_ROLLBACK_LOCKS
The total number of rollback locks.
- GC_SAVE_ROLLBACK_LOCKS
The number of rollback save locks (Oracle7 only).
- GC_SEGMENTS
The maximum number of segments that may have activities impacting space management performed on them simultaneously (Oracle7 only).
- INSTANCE_GROUPS
Assigns the instance to one or more specified groups (Oracle8 only).
- LM_LOCKS
The number of locks that will be configured for the lock manager (Oracle8 only).
- LM_PROCS
The number of processes for the lock manager (Oracle8 only).
- LM_RESS
The number of resources that can be locked by each lock manager instance (Oracle8 only).
- OPS_ADMIN_GROUP
Assigns the instance to a group for monitoring (Oracle8 only). ...
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.