Search notes:

Oracle SQL Plan operation PX BLOCK ITERATOR

create table tq84_tab (
   num   integer           check (num between 1 and 100000) not null,
   txt  varchar2(10)
);
 
insert into tq84_tab
select
   level,
   dbms_random.string('a', 10)
from
   dual
connect by level <= 100000;
 
explain plan for
select /*+ parallel */
   max(txt)
from
   tq84_tab
;  
 
 
select * from dbms_xplan.display(format=>'basic');
--
-- -------------------------------------------
-- | Id  | Operation              | Name     |
-- -------------------------------------------
-- |   0 | SELECT STATEMENT       |          |
-- |   1 |  SORT AGGREGATE        |          |
-- |   2 |   PX COORDINATOR       |          |
-- |   3 |    PX SEND QC (RANDOM) | :TQ10000 |
-- |   4 |     SORT AGGREGATE     |          |
-- |   5 |      PX BLOCK ITERATOR |          |
-- |   6 |       TABLE ACCESS FULL| TQ84_TAB |
-- -------------------------------------------

drop table tq84_tab;

See also

Plan operations

Index