Musíte mít štěstí, aby byl dotaz ještě v paměti.
SQL> select plan_table_output
from v$sql s, table(dbms_xplan.display_cursor(s.sql_id, s.child_number,'basic')) t
where s.sql_text like 'SELECT T0.PKUKID, T0.PKDELN%';
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
EXPLAINED SQL STATEMENT:
------------------------
SELECT T0.PKUKID, T0.PKDELN, T0.PKDOCO, T0.PKDCTO, T0.PKKCOO,
T0.PKLNID, T0.PKAN8, T0.PKSHAN, T0.PKITM, T0.PKLITM, T0.PKAITM,
T0.PKLOTN, T0.PKSOQS, T0.PKUOM, T0.PKCPIT, T0.PKCPIL, T0.PKCPIA,
T0.PKBSCLBLV, T0.PKCUTY, T0.PKCTUOM, T0.PKFQTY, T0.PKBSCNBLY, T0.PKKIT,
T0.PKKITL, T0.PKKITA, T0.PKASID, T0.PKSN, T0.PKCTSN, T0.PKBSCMNLY,
T0.PKBSCMXLY, T0.PKBSCPCFL, T0.PKBSCQTYOU, T0.PKBSCQTYLY,
T0.PKBSCPACGR, T0.PKURCD, T0.PKURAB, T0.PKURAT, T0.PKURDT, T0.PKURRF,
T0.PKUSER, T0.PKPID, T0.PKJOBN, T0.PKUPMJ, T0.PKTDAY, T0.PKUPC1,
T1.PKAN8, T1.PKITM, T1.PKKIT, T1.PKCPIT, T1.PKUPC1, T1.PKBSCQTYOU,
T1.PKBSCQTYLY, T1.PKFQTY, T1.PKEFTJ, T1.PKEXDJ FROM PRODDTA.F5547PAC
T0,PRODDTA.F5541PAC T1 WHERE ( ( T0.PKDELN = :KEY1 AND T0.PKFQTY <
T1.PKFQTY AND T0.PKBSCLBLV = :KEY2 ) AND ( T0.PKCUTY = :KEY3 AND
T1.PKEXDJ >= :KEY4 AND T1.PKEFTJ <= :KEY5 ) ) AND (
T0.PKSHAN=T1.PKAN8 AND T0.PKITM=T1.PKITM AND T0.PKKIT=T1.PKKIT AND
T0.PKCPIT=T1.PKCPIT AND T0.PKUPC1=T1.PKUPC1 ) ORDER BY T0.PKDELN
ASC,T0.PKCPIT ASC
Plan hash value: 2410794740
-----------------------------------------------------
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
| Id | Operation | Name |
-----------------------------------------------------
| 0 | SELECT STATEMENT | |
| 1 | SORT ORDER BY | |
| 2 | NESTED LOOPS | |
| 3 | NESTED LOOPS | |
| 4 | TABLE ACCESS BY INDEX ROWID| F5547PAC |
| 5 | INDEX RANGE SCAN | F5547PAC_3 |
| 6 | INDEX RANGE SCAN | F5541PAC_0 |
| 7 | TABLE ACCESS BY INDEX ROWID | F5541PAC |
-----------------------------------------------------