SELECT CB||CE||NVL(TO_CHAR(CG,'YYYYMMDD'),' ')||C01||C02
FROM
D21V2_ENG WHERE CB = :0000 AND CE >= :0001 ORDER BY CB,CE
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 24562 2.03 1.98 0 0 0 0
Fetch 49124 4.53 5.01 736 153224 0 245621
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 73687 6.56 6.99 736 153224 0 245621
Misses in library cache during parse: 0
Optimizer goal: RULE
Parsing user id: 34
********************************************************************************
SELECT NVL(TO_CHAR(CG,'YYYYMMDD'),' ')||C01||C02||C03||NVL(TO_CHAR(C04,
'YYYYMMDD'),' ')
FROM
D21V2_ENGHIE WHERE CB = :0000
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 24562 4.49 3.56 0 0 0 0
Execute 24562 1.51 1.40 0 0 0 0
Fetch 24562 1.42 1.43 473 98248 0 24562
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 73686 7.42 6.39 473 98248 0 24562
Misses in library cache during parse: 0
Optimizer goal: RULE
Parsing user id: 34
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID D21V2_ENGHIE
1 INDEX UNIQUE SCAN (object id 103367)
********************************************************************************
SELECT NVL(TO_CHAR(CG,'YYYYMMDD'),' ')||C01||C02||C03||C04||C05||C06||C07
FROM
D21V2_ENGSEC WHERE CB = :0000
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 24562 2.64 2.66 0 0 0 0
Execute 24562 1.44 1.23 0 0 0 0
Fetch 24562 0.49 0.33 0 24562 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 73686 4.57 4.22 0 24562 0 0
Misses in library cache during parse: 0
Optimizer goal: RULE
Parsing user id: 34
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS BY INDEX ROWID D21V2_ENGSEC
1 INDEX UNIQUE SCAN (object id 103435)
********************************************************************************
SELECT NVL(TO_CHAR(CG,'YYYYMMDD'),' ')||C01||C02||NVL(TO_CHAR(C03,'YYYYMMDD'),
' ')||NVL(TO_CHAR(C04,'YYYYMMDD'),' ')||C05||NVL(TO_CHAR(C06,
'S00000000000D00'),' ')||NVL(TO_CHAR(C07,'S00000000000D00'),' ')||C08||C09
FROM
D21V9_PARPAR WHERE CB = :0000
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1445 0.16 0.16 0 0 0 0
Execute 1445 0.06 0.07 0 0 0 0
Fetch 1445 0.07 0.09 0 2890 0 1445
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4335 0.29 0.32 0 2890 0 1445
Misses in library cache during parse: 0
Optimizer goal: RULE
Parsing user id: 34
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID D21V9_PARPAR
1 INDEX UNIQUE SCAN (object id 105169)
Trace file: ora_87032_pletst.trc
Trace file compatibility: 8.00.04
Sort options: default
1 session in tracefile.
75139 user SQL statements in trace file.
2 internal SQL statements in trace file.
75141 SQL statements in trace file.
15 unique SQL statements in trace file.
749956 lines in trace file.
Partager