If a parent connection repeatedly runs a query that uses intra-query parallelism, several INT: EXCHANGE child connections may be spawned and then dropped each time the query runs.
This is not easy to observe while the loop is running since the INT: EXCHANGE connections all look the same... except for the fact the connection numbers grow by leaps and bounds, and there may be gaps when short-lived child connections go completely unnoticed.
Is there a cumulative count of child connections available? Such a counter might help to highlight an abuse of intra-query parallelism.
(if not, consider this a request).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.