-- Purpose: Queries v$pq_tqstat for px info set pages 999 break on dfo_number on tq_id SELECT dfo_number, tq_id, server_type, process, num_rows, bytes FROM v$pq_tqstat ORDER BY dfo_number DESC, tq_id, server_type DESC , process;