alter session set "_complex_view_merging"=false;

select '| Operation | Name | Starts | E-Rows | A-Rows | Buffers | Reads | Writes | E-Time |' as "Plan Table" from dual
union all
select '------------------------------------------------------------------------------------------------------------------------'
from dual
union all
select rpad('| '||substr(lpad(' ',1*(depth))||operation|| decode(options, null,'',' '||options), 1, 33), 34, ' ')||'|'||
          rpad(substr(object_name||' ',1, 19), 20, ' ')||'|'||
          lpad(decode(starts,null,' ',
                         decode(sign(starts-1000), -1, starts||' ',
                         decode(sign(starts-1000000), -1, round(starts/1000)||'K',
                         decode(sign(starts-1000000000), -1, round(starts/1000000)||'M',
                                           round(starts/1000000000)||'G')))), 8, ' ') || '|' ||
          lpad(decode(cardinality,null,' ',
                         decode(sign(cardinality-1000), -1, cardinality||' ',
                         decode(sign(cardinality-1000000), -1, round(cardinality/1000)||'K',
                         decode(sign(cardinality-1000000000), -1, round(cardinality/1000000)||'M',
                                            round(cardinality/1000000000)||'G')))), 8, ' ') || '|' ||
          lpad(decode(outrows,null,' ',
                         decode(sign(outrows-1000), -1, outrows||' ',
                         decode(sign(outrows-1000000), -1, round(outrows/1000)||'K',
                         decode(sign(outrows-1000000000), -1, round(outrows/1000000)||'M',
                                            round(outrows/1000000000)||'G')))), 8, ' ') || '|' ||
          lpad(decode(crgets,null,' ',
                         decode(sign(crgets-10000000), -1, crgets||' ',
                         decode(sign(crgets-1000000000), -1, round(crgets/1000000)||'M',
                                            round(crgets/1000000000)||'G'))), 9, ' ') || '|' ||
          lpad(decode(reads,null,' ',
                         decode(sign(reads-10000000), -1, reads||' ',
                         decode(sign(reads-1000000000), -1, round(reads/1000000)||'M',
                                            round(reads/1000000000)||'G'))), 8, ' ') || '|' ||
          lpad(decode(writes,null,' ',
                         decode(sign(writes-10000000), -1, writes||' ',
                         decode(sign(writes-1000000000), -1, round(writes/1000000)||'M',
                                            round(writes/1000000000)||'G'))), 8, ' ') || '|' ||
          lpad(decode(etime,null,' ',
                         decode(sign(etime-10000000), -1, etime||' ',
                         decode(sign(etime-1000000000), -1, round(etime/1000000)||'M',
                                            round(etime/1000000000)||'G'))), 8, ' ') || '|' as "Explain plan"
from
       (select /*+ no_merge */
                  p.id,p.parent_id,
                  p.HASH_VALUE, p.ID, p.DEPTH, p.POSITION, p.OPERATION,
                  p.OPTIONS, p.COST COST, p.CARDINALITY CARDINALITY,
                  p.BYTES BYTES, p.OBJECT_NODE, p.OBJECT_OWNER,
                  p.OBJECT_NAME, p.OTHER_TAG, p.PARTITION_START,
                  p.PARTITION_STOP, p.DISTRIBUTION, pa.starts,
                  pa.OUTPUT_ROWS outrows, pa.CR_BUFFER_GETS crgets,
                  pa.DISK_READS reads, pa.DISK_WRITES writes,
                  pa.ELAPSED_TIME etime
        from v$sql_plan_statistics_all pa,
               V$sql_plan p,v$session sess
        where sid = &sid and p.hash_value = sql_hash_value
           and p.CHILD_NUMBER= 0
           and p.hash_value = pa.hash_value(+)
           and pa.child_number(+) = 0  order by p.id)
union all
        select '------------------------------------------------------------------------------------------------------------------------' from dual
/