doc

    Name:    pqoplan3.sql

    Author:  Mark Gurry

    The following query shows the Oracle7.3 parallel query access path. 
#

select substr(lpad(' ',2*(level-1)) ||
           decode(id, 0, statement_id, operation)  ||
           ' ' || options  || ' ' || object_name  || other_tag, 1, 79)  
                             "Plan Step with Parallel Path"
 from plan_table
 start with id = 0
connect by prior id = parent_id
         and prior nvl(statement_id, 'X') = nvl(statement_id, 'X')
/