Name
PARALLEL_ADAPTIVE_MULTI_USER
Synopsis
Value: TRUE | FALSE
Default: derived
Dynamic: ALTER SYSTEM
Specifies whether Oracle will dynamically adjust the requested degree of parallelism based on system load at the time the query begins execution. The default is taken from the value of PARALLEL_AUTOMATIC_TUNING. The algorithm used assumes that the system is tuned for optimal performance in a single-user environment.
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.