Parallel Query Management ------------------------- Parallel Query Usage per sec per xact count % of total ------------------------ ------------ ---------- --------- ---------- Total Parallel Queries 0.1 0.3 19 n/a WP Adjustments Made Due to WP Limit 0.0 0.0 0 0.0 % Due to No WPs 0.0 0.0 0 0.0 % Merge Lock Requests per sec per xact count % of total ------------------------ ------------ ---------- --------- ---------- Network Buffer Merge Locks Granted with no wait 1.1 5.0 320 21.3 % Granted after wait 3.9 18.4 1179 78.7 % Result Buffer Merge Locks Granted with no wait 0.0 0.0 0 0.0 % Granted after wait 0.0 0.0 0 0.0 % Work Table Merge Locks Granted with no wait 0.0 0.0 0 0.0 % Granted after wait 0.0 0.0 0 0.0 % ------------------------ ------------ ---------- --------- ---------- Total # of Requests 5.0 23.4 1499 Sort Buffer Waits per sec per xact count % of total ------------------------ ------------ ---------- --------- ---------- Producer Waits 0.0 0.1 8 100.0 % Consumer Waits 0.0 0.0 0 0.0 % ------------------------ ------------ ---------- --------- ---------- Total # of Waits 0.0 0.1 8
