格式化v$sql_plan查看实际执行计划

1、先去v$session_longops查看正在执行的6秒以上的session

    SELECT * FROM V$SESSION_LONGOPS t WHERE sofar<> totalwork --未执行完的;

2、通过以下sql对实际执行过的执行计划进行格式化    

SELECT LPAD(' ', 2 * (LEVEL - 1)) || OPERATION || ' ' ||
       DECODE(ID, 0, 'Cost = ' || POSITION) "OPERATION",
       OPTIONS,
       OBJECT_NAME,
       COST,
       CARDINALITY,
       CPU_COST,
       IO_COST/*,
       ACCESS_PREDICATES,
       FILTER_PREDICATES*/
  FROM V$SQL_PLAN
 START WITH (ADDRESS = '0000000459AE0110' AND HASH_VALUE = 2236084057
            /*and child_number = :child*/
            AND ID = 0)
CONNECT BY PRIOR ID = PARENT_ID
       AND PRIOR ADDRESS = ADDRESS
       AND PRIOR HASH_VALUE = HASH_VALUE
       AND PRIOR CHILD_NUMBER = CHILD_NUMBER
 ORDER BY ID, POSITION;