Default dop vs parallel_degree_limit when auto DOP enabled

konala-Oracle
konala-Oracle Posts: 2 Green Ribbon

why default dop is taking precedence over parallel_degree_limit when auto DOP enabled

Answers

  • konala-Oracle
    konala-Oracle Posts: 2 Green Ribbon
    edited September 2021

    How to limit the parallelism for any session with out resource manager? even if parallel_degree_limit set to integer, the query using default dop with higher value than what was set in parallel_degree_limit. can someone explain the default dop behavior?