January 2018

Why Isn’t My Parallel Query Running in Parallel?

If everything is set correctly and the plan shows that it is parallel, Oracle may still not actually assign the full number of threads (or even any extra threads at all). Here is a simple query to get the reason that Oracle downgraded the degree of parallel for a query: select SID,sql_id,sql_exec_id, sql_exec_start, case otherstat_2_value […]

Read more →