Answers

Question and Answer:

  Home  Oracle Certification

⟩ Explain What is the use of PARALLEL_ADAPTIVE_MULTI_USER initialization parameter?

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.

 212 views

More Questions for you: