/*+ parallel(S,8) */ Changed to /*+ parallel(S,4) */
Mansi, March 14, 2023 - 3:35 pm UTC
Thank you Connor for the answer.
I understood that /*+ parallel(S,8) */ is making 17 parallel instances, but I now I reduced it to /*+ parallel(S,4) */ to match the CPU capacity and /*+ parallel(S,8) */ is making query too slow.
Still I see 17 Instances, why it is not taking hint as 4. Is any other paramater I need to check as /*+ parallel(S,8) */ is really making query and system slow and it show heavy IOs.
March 21, 2023 - 6:13 pm UTC
Is "S" a table alias in your query? It doesn't appear in the pseudo example in the post
Table Alias
Mansi, March 22, 2023 - 5:06 am UTC
Yes S Is a table Alias used in entire query.