Name
GC_ROLLBACK_LOCKS
Synopsis
Value: 1 - unlimited
Default: 20
Specifies, for each rollback segment, the number of distributed locks available for simultaneously modified rollback segment blocks for Parallel Server. The default is adequate for most applications. Each instance must have identical values. Obsolete with Oracle9i.
Syntax
GC_ROLLBACK_LOCKS = 'rs_list
=lock_count
[!blocks
][R][EACH][:...]'
Keywords
- rs_list
One or more rollback segments listed by their segment numbers, or ranges of segment numbers, with comma separators.
- lock_count
Number of PCM locks assigned to rs_list.
- ! blocks
Number of contiguous blocks covered by one lock. The default is noncontiguous blocks.
- R
Indicates that these locks are releasable and are drawn as needed from the pool of releasable locks.
- EACH
Indicates that each rollback segment in rs_list is assigned a separate set of lock_count PCM locks.
Get Oracle in a Nutshell 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.