Oracle Certification Interview Question:

Explain What is the use of PARALLEL_ADAPTIVE_MULTI_USER initialization parameter?

Submitted by: Administrator

When we set to PARALLEL_ADAPTIVE_MULTI_USER true enables an adaptive algorithm designed to improve performance in multiuser environments that use parallel execution. The algorithm automatically reduces the request degree of parallelism based on the degree at the system load at query startup time.
Submitted by: Administrator