doc

    Name:    pqoplan2.sql

    Author:  Mark Gurry

    The following query shows an Oracl 7.1 and 7.2 script that accesses
    the plan table to obtain the parallel query access path. The output 
    contains the SQL statement.
#

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