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;