doc

    Name:    pqoplan1.sql

    Author:  Mark Gurry

    The following query shows an Oracle7.1 and 7.2 script that accesses
    the plan table to obtain the parallel query access path. 
#

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