select * from table( dbms_xplan.display_cursor( '1cz9naf22d7jw','0' ,'advanced'));
SQL_ID 1cz9naf22d7jw, child number 0
-------------------------------------
Plan hash value: 773930837
---------------------------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop |
---------------------------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 21826 (100)| | | |
| 1 | HASH GROUP BY | | 2 | 114 | 21826 (1)| 00:04:22 | | |
| 2 | VIEW | | 2 | 114 | 21825 (1)| 00:04:22 | | |
| 3 | UNION-ALL | | | | | | | |
|* 4 | FILTER | | | | | | | |
| 5 | NESTED LOOPS | | 1 | 236 | 17374 (1)| 00:03:29 | | |
| 6 | NESTED LOOPS | | 1 | 236 | 17374 (1)| 00:03:29 | | |
| 7 | NESTED LOOPS | | 1 | 197 | 17372 (1)| 00:03:29 | | |
| 8 | NESTED LOOPS | | 1 | 182 | 17371 (1)| 00:03:29 | | |
|* 9 | FILTER | | | | | | | |
|* 10 | HASH JOIN OUTER | | 1 | 158 | 17369 (1)| 00:03:29 | | |
|* 11 | TABLE ACCESS BY GLOBAL INDEX ROWID | CON_CONTENT_MOVE | 1 | 94 | 8 (0)| 00:00:01 | ROWID | ROWID |
|* 12 | INDEX RANGE SCAN | INDXCON_CONTENT_MOVE_MID_21 | 37 | | 4 (0)| 00:00:01 | | |
| 13 | VIEW | | 609 | 38976 | 17361 (1)| 00:03:29 | | |
| 14 | HASH GROUP BY | | 609 | 43848 | 17361 (1)| 00:03:29 | | |
|* 15 | FILTER | | | | | | | |
|* 16 | HASH JOIN | | 609 | 43848 | 17360 (1)| 00:03:29 | | |
|* 17 | TABLE ACCESS BY INDEX ROWID | BILL_OM_EXP | 211 | 7596 | 38 (0)| 00:00:01 | | |
|* 18 | INDEX RANGE SCAN | IDX1_BILL_OM_EXP | 45 | | 12 (0)| 00:00:01 | | |
| 19 | TABLE ACCESS BY GLOBAL INDEX ROWID| BILL_OM_OUTSTOCK_DTL | 927K| 31M| 17320 (1)| 00:03:28 | ROWID | ROWID |
|* 20 | INDEX RANGE SCAN | INDXBILL_OM_OUTSTOCK_DTL_MID_9 | 26390 | | 6350 (1)| 00:01:17 | | |
| 21 | TABLE ACCESS BY INDEX ROWID | CM_DEFCELL | 1 | 24 | 2 (0)| 00:00:01 | | |
|* 22 | INDEX UNIQUE SCAN | M1_PK_CM_DEFCELL | 1 | | 1 (0)| 00:00:01 | | |
|* 23 | TABLE ACCESS BY INDEX ROWID | CM_DEFAREA | 1 | 15 | 1 (0)| 00:00:01 | | |
|* 24 | INDEX UNIQUE SCAN | M1_PK_CM_DEFAREA | 1 | | 0 (0)| | | |
|* 25 | INDEX UNIQUE SCAN | SYS_C0014916 | 1 | | 1 (0)| 00:00:01 | | |
|* 26 | TABLE ACCESS BY INDEX ROWID | ITEM | 1 | 39 | 2 (0)| 00:00:01 | | |
|* 27 | FILTER | | | | | | | |
| 28 | NESTED LOOPS | | 1 | 184 | 4451 (1)| 00:00:54 | | |
| 29 | NESTED LOOPS | | 1 | 184 | 4451 (1)| 00:00:54 | | |
| 30 | NESTED LOOPS | | 1 | 145 | 4449 (1)| 00:00:54 | | |
| 31 | NESTED LOOPS | | 1 | 130 | 4448 (1)| 00:00:54 | | |
| 32 | NESTED LOOPS | | 1 | 106 | 4446 (1)| 00:00:54 | | |
|* 33 | TABLE ACCESS FULL | BILL_CONTAINER_TASK | 1 | 40 | 4442 (1)| 00:00:54 | | |
|* 34 | TABLE ACCESS BY GLOBAL INDEX ROWID | BILL_CONTAINER_TASK_DTL | 6 | 396 | 4 (0)| 00:00:01 | ROWID | ROWID |
|* 35 | INDEX RANGE SCAN | PK_BILL_CONTAINER_TASK_DTL_MID | 6 | | 3 (0)| 00:00:01 | | |
| 36 | TABLE ACCESS BY INDEX ROWID | CM_DEFCELL | 1 | 24 | 2 (0)| 00:00:01 | | |
|* 37 | INDEX UNIQUE SCAN | M1_PK_CM_DEFCELL | 1 | | 1 (0)| 00:00:01 | | |
|* 38 | TABLE ACCESS BY INDEX ROWID | CM_DEFAREA | 1 | 15 | 1 (0)| 00:00:01 | | |
|* 39 | INDEX UNIQUE SCAN | M1_PK_CM_DEFAREA | 1 | | 0 (0)| | | |
|* 40 | INDEX UNIQUE SCAN | SYS_C0014916 | 1 | | 1 (0)| 00:00:01 | | |
|* 41 | TABLE ACCESS BY INDEX ROWID | ITEM | 1 | 39 | 2 (0)| 00:00:01 | | |
---------------------------------------------------------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id): ...篇幅问题不在此显示
Outline Data...篇幅问题不在此显示
Peeked Binds (identified by position):
--------------------------------------
1 - :1 (VARCHAR2(30), CSID=873): 'K7551'
2 - :2 (VARCHAR2(30), CSID=873): '2017-01-18 23:45:32'
3 - :3 (VARCHAR2(30), CSID=873): '2017-01-20 15:12:35'
4 - :4 (VARCHAR2(30), CSID=873): 'K7551'
5 - :5 (VARCHAR2(30), CSID=873): 'SD'
6 - :6 (VARCHAR2(30), CSID=873): 'BL'
7 - :7 (VARCHAR2(30), CSID=873): 'TM'
8 - :8 (VARCHAR2(30), CSID=873): 'TT'
9 - :9 (VARCHAR2(30), CSID=873): 'BS'
10 - :10 (VARCHAR2(30), CSID=873): 'K7551'
11 - :11 (VARCHAR2(30), CSID=873): 'SD'
12 - :12 (VARCHAR2(30), CSID=873): 'BL'
13 - :13 (VARCHAR2(30), CSID=873): 'TM'
14 - :14 (VARCHAR2(30), CSID=873): 'TT'
15 - :15 (VARCHAR2(30), CSID=873): 'BS'
16 - :16 (VARCHAR2(30), CSID=873): '2017-01-18 23:45:32'
17 - :17 (VARCHAR2(30), CSID=873): '2017-01-20 15:12:35'
Predicate Information (identified by operation id):
---------------------------------------------------
4 - filter(TO_DATE(:3,'yyyy-mm-dd hh24:mi:ss')>TO_DATE(:2,'yyyy-mm-dd hh24:mi:ss'))
9 - filter("BOE"."OUTSTOCK_NO" IS NULL)
10 - access("PAPER_NO"="BOE"."OUTSTOCK_NO" AND "LOCNO"="BOE"."LOCNO" AND "PAPER_TYPE"=CASE WHEN ("BOE"."LOCNO" IS NOT NULL) THEN 'HO'
ELSE 'HO' END )
11 - filter(("LOCNO"=:1 AND ("BOX_NO" IS NULL OR "BOX_NO"='N') AND "PRE_FLAG"='0' AND "ITEM_TYPE"='0' AND "QUALITY"='0' AND
"PAPER_TYPE"<>'CN'))
12 - access("CREATETM">=TO_DATE(:2,'yyyy-mm-dd hh24:mi:ss') AND "CREATETM"
15 - filter(:4=:1)
16 - access("T1"."LOCNO"="T2"."LOCNO" AND "T1"."EXP_NO"="T2"."EXP_NO")
17 - filter(("T1"."BUSINESS_TYPE"='20' AND "T1"."EXP_DATE">SYSDATE@!-31))
18 - access("T1"."LOCNO"=:1)
filter("T1"."LOCNO"=:4)
20 - access("T2"."LOCNO"=:4)
filter("T2"."LOCNO"=:1)
22 - access("C"."CELL_NO"="CELL_NO" AND "C"."LOCNO"=:1)
23 - filter("CD"."ATTRIBUTE_TYPE"='0')
24 - access("CD"."AREA_NO"="C"."AREA_NO" AND "CD"."LOCNO"=:1 AND "CD"."WARE_NO"="C"."WARE_NO")
25 - access("IT"."ITEM_NO"="ITEM_NO")
26 - filter(("IT"."SYS_NO"=:5 OR "IT"."SYS_NO"=:6 OR "IT"."SYS_NO"=:7 OR "IT"."SYS_NO"=:8 OR "IT"."SYS_NO"=:9))
27 - filter(TO_DATE(:17,'yyyy-mm-dd hh24:mi:ss')>TO_DATE(:16,'yyyy-mm-dd hh24:mi:ss'))
33 - filter(("BCT"."LOCNO"=:10 AND "BCT"."BUSINESS_TYPE"='0' AND INTERNAL_FUNCTION("BCT"."USE_TYPE") AND
"BCT"."AUDITTM">=TO_DATE(:16,'yyyy-mm-dd hh24:mi:ss') AND "BCT"."STATUS"='13' AND "BCT"."AUDITTM"
34 - filter(("BCTD"."ITEM_TYPE"='0' AND "BCTD"."QUALITY"='0'))
35 - access("BCTD"."LOCNO"=:10 AND "BCT"."CONTASK_NO"="BCTD"."CONTASK_NO")
37 - access("C"."CELL_NO"=CASE "BCT"."USE_TYPE" WHEN 'A' THEN "BCTD"."D_CELL_NO" WHEN 'C' THEN "BCTD"."S_CELL_NO" ELSE '' END AND
"C"."LOCNO"=:10)
38 - filter("CD"."ATTRIBUTE_TYPE"='0')
39 - access("CD"."AREA_NO"="C"."AREA_NO" AND "CD"."LOCNO"=:10 AND "CD"."WARE_NO"="C"."WARE_NO")
40 - access("IT"."ITEM_NO"="BCTD"."ITEM_NO")
41 - filter(("IT"."SYS_NO"=:11 OR "IT"."SYS_NO"=:12 OR "IT"."SYS_NO"=:13 OR "IT"."SYS_NO"=:14 OR "IT"."SYS_NO"=:15))
Column Projection Information (identified by operation id): ....篇幅问题,不在此显示