Do parallel hints override Resource Manager limits?
I'm running a EDW (Exadata) with 11.2.0.2
BP7. I'm trying to create a short-term Resource Manager plan that makes
sure that one user can't consume a ridiculous number of parallel slaves.
Because of our batch processing, certain indexes on certain tables need to have a large DOP. However, when one user in particular hits a number of them in a huge query, we start seeing a lot of parallel slave usage, obviously.
We're 'educating' the user but this question is about the theory with Resource Manager.
I've created a single group, PQTEST_GROUP, of which this user is the only member. I've created a PQTEST_PLAN which takes the 'standard' plan and has the sole difference of restricting members of PQTEST_GROUP of having a maximum DOP of 4 and a maximum number of sessions of 2 (just in case said user decided he'd run multiple queries to bother me)
Because of our batch processing, certain indexes on certain tables need to have a large DOP. However, when one user in particular hits a number of them in a huge query, we start seeing a lot of parallel slave usage, obviously.
We're 'educating' the user but this question is about the theory with Resource Manager.
I've created a single group, PQTEST_GROUP, of which this user is the only member. I've created a PQTEST_PLAN which takes the 'standard' plan and has the sole difference of restricting members of PQTEST_GROUP of having a maximum DOP of 4 and a maximum number of sessions of 2 (just in case said user decided he'd run multiple queries to bother me)
0