with 
  q_sess as (select sql_id, sql_child_number, s.sql_exec_id, s.sid 
               from v$session s where sid = 803/*SID*/),
  q_plan as (select rownum rn, q.id, lpad(' ',level *2,' ')||q.oper as operation, q.object_name, q.cardinality, q.bytes, q.cost 
               from (select id, parent_id, operation||' '||options oper, object_name, cardinality, bytes, cost  
                       from v$sql_plan p 
                      where (p.sql_id, p.child_number) 
                         in (select sql_id, sql_child_number from q_sess)
                    ) q
            connect by prior q.id = q.parent_id
              start with q.id = 0)              
select q_plan.*, to_char(lo.sofar/lo.totalwork*100,'990') pct, lo.elapsed_seconds, lo.time_remaining 
  from q_plan
     , q_sess
     , v$session_longops lo 
  where lo.sid(+) = q_sess.sid
    and lo.sql_plan_line_id(+) = q_plan.id
    and lo.sql_exec_id(+) = q_sess.sql_exec_id 
  order by rn;

with 
  q_sess as (select sql_id, sql_child_number, s.sql_exec_id, s.sid 
               from v$session s where sid = 32/*SID*/),
  q_plan as (select id, lpad(' ',depth *2,' ')||operation||' '||options operation, object_name, cardinality, bytes, cost  
               from v$sql_plan p 
              where (p.sql_id, p.child_number) in (select sql_id, sql_child_number from q_sess)                     
            )              
select q_plan.*, round(lo.sofar/lo.totalwork*100) pct, lo.elapsed_seconds, lo.time_remaining 
  from q_plan
     , q_sess
     , v$session_longops lo 
 where lo.sid(+) = q_sess.sid
   and lo.sql_plan_line_id(+) = q_plan.id
   and lo.sql_exec_id(+) = q_sess.sql_exec_id 
 order by id;

with
  q_sess as (select sql_id, sql_child_number, s.sql_exec_id, s.sid
               from v$session s where sid = 1303/*SID*/),
  q_plan as (select id, lpad(' ',depth * 2,' ')||operation||' '||options operation, object_name, cardinality, bytes, cost
               from v$sql_plan p
              where (p.sql_id, p.child_number) in (select sql_id, sql_child_number from q_sess)                   
            )            
select q_plan.*
     , round(lo.sofar/lo.totalwork*100) pct, lo.elapsed_seconds, lo.time_remaining
  from q_plan
     , q_sess
     , v$session_longops lo
 where lo.sid(+) = q_sess.sid
   and lo.sql_plan_line_id(+) = q_plan.id
   and lo.sql_exec_id(+) = q_sess.sql_exec_id
   and lo.sql_id(+) = q_sess.sql_id
 order by id;