Search notes:

Oracle: V$PQ_SESSTAT

v$pq_sesstat collects statistics of parallel SQL executions in one's session.

This column last_query is especially interesting because it shows the statistics for the most recently executed SQL statement in a session

select * from v$pq_sesstat order by statistic;

select /*+ parallel */ count(*) from all_objects;

select * from v$pq_sesstat order by statistic;

See also