Limiting number of parallel query slaves
Is it possible to limit the amount of parallel query slaves spawned per user?
I have parallel_max_servers set to 64, but the first user can sometimes spawn all 64!! which means that everyone else runs in serial mode.
I've got memory usage pinned by pga_aggregate_target on a windows box, so I don't run into 'out of memory process' issues.
I don't think you can limit this per-session.
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
afaik no, you canīt set a limit for each user, what tou can do is :
- set a (small) degree for each table involved
- use PARALLEL_ADAPTIVE_MULTI_USER, with this the first user will NOT be able to use all the slaves, some will be reserved, and in the future, with new users trying to do parallel things, more slaves will be "removed" from the first user. But this algorithm is CLOSED, you canīt change it, you canīt specify what portion os slaves to each user...
You can use Resource manager to limit the number of px slaves per consumer group.
You can modify that to a case where the consumer group has one user only and hence limit px slaves per user
Gonna look at PARALLEL_ADAPTIVE_MULTI_USER
Click Here to Expand Forum to Full Width