Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Plan hash value: 2993755469
- --------------------------------------------------------------------------------------------------------------------
- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
- --------------------------------------------------------------------------------------------------------------------
- | 0 | UPDATE STATEMENT | | 1 | 75 | 18 (6)| 00:00:01 |
- | 1 | UPDATE | PO_LINE_LOCATIONS_ALL | | | | |
- | 2 | NESTED LOOPS | | 1 | 75 | 13 (0)| 00:00:01 |
- | 3 | NESTED LOOPS | | 4 | 75 | 13 (0)| 00:00:01 |
- | 4 | VIEW | VW_NSO_1 | 4 | 52 | 9 (0)| 00:00:01 |
- | 5 | SORT UNIQUE | | 4 | 59 | 9 (0)| 00:00:01 |
- | 6 | UNION-ALL | | | | | |
- |* 7 | FILTER | | | | | |
- |* 8 | TABLE ACCESS BY INDEX ROWID | PO_LINE_LOCATIONS_ALL | 1 | 9 | 2 (0)| 00:00:01 |
- |* 9 | INDEX UNIQUE SCAN | PO_LINE_LOCATIONS_U1 | 1 | | 1 (0)| 00:00:01 |
- |* 10 | FILTER | | | | | |
- |* 11 | TABLE ACCESS BY INDEX ROWID BATCHED| PO_LINE_LOCATIONS_ALL | 1 | 14 | 3 (0)| 00:00:01 |
- |* 12 | INDEX RANGE SCAN | PO_LINE_LOCATIONS_N1 | 1 | | 2 (0)| 00:00:01 |
- |* 13 | FILTER | | | | | |
- |* 14 | TABLE ACCESS BY INDEX ROWID BATCHED| PO_LINE_LOCATIONS_ALL | 1 | 14 | 3 (0)| 00:00:01 |
- |* 15 | INDEX RANGE SCAN | PO_LINE_LOCATIONS_N14 | 2 | | 2 (0)| 00:00:01 |
- |* 16 | FILTER | | | | | |
- |* 17 | TABLE ACCESS BY INDEX ROWID BATCHED| PO_LINE_LOCATIONS_ALL | 1 | 22 | 1 (0)| 00:00:01 |
- |* 18 | INDEX RANGE SCAN | PO_LINE_LOCATIONS_N5 | 1 | | 1 (0)| 00:00:01 |
- |* 19 | INDEX UNIQUE SCAN | PO_LINE_LOCATIONS_U1 | 1 | | 0 (0)| 00:00:01 |
- |* 20 | TABLE ACCESS BY INDEX ROWID | PO_LINE_LOCATIONS_ALL | 1 | 62 | 1 (0)| 00:00:01 |
- |* 21 | TABLE ACCESS BY INDEX ROWID | PO_LINES_ALL | 1 | 22 | 2 (0)| 00:00:01 |
- |* 22 | INDEX UNIQUE SCAN | PO_LINES_U1 | 1 | | 1 (0)| 00:00:01 |
- --------------------------------------------------------------------------------------------------------------------
- Query Block Name / Object Alias (identified by operation id):
- -------------------------------------------------------------
- 1 - SEL$AC90CD92
- 4 - SET$FCA7A018 / VW_NSO_1@SEL$AC90CD92
- 5 - SET$FCA7A018
- 7 - SEL$A731BD80
- 8 - SEL$A731BD80 / PO_LINE_LOCATIONS_ALL@SEL$8
- 9 - SEL$A731BD80 / PO_LINE_LOCATIONS_ALL@SEL$8
- 10 - SEL$96467BBE
- 11 - SEL$96467BBE / PO_LINE_LOCATIONS_ALL@SEL$11
- 12 - SEL$96467BBE / PO_LINE_LOCATIONS_ALL@SEL$11
- 13 - SEL$03235BA3
- 14 - SEL$03235BA3 / PO_LINE_LOCATIONS_ALL@SEL$14
- 15 - SEL$03235BA3 / PO_LINE_LOCATIONS_ALL@SEL$14
- 16 - SEL$45068F18
- 17 - SEL$45068F18 / PO_LINE_LOCATIONS_ALL@SEL$17
- 18 - SEL$45068F18 / PO_LINE_LOCATIONS_ALL@SEL$17
- 19 - SEL$AC90CD92 / PO_LINE_LOCATIONS_ALL@SEL$2
- 20 - SEL$AC90CD92 / PO_LINE_LOCATIONS_ALL@SEL$2
- 21 - SEL$C8360722 / PO_LINES_ALL@SEL$5
- 22 - SEL$C8360722 / PO_LINES_ALL@SEL$5
- Outline Data
- -------------
- /*+
- BEGIN_OUTLINE_DATA
- INDEX_RS_ASC(@"SEL$C8360722" "PO_LINES_ALL"@"SEL$5" ("PO_LINES_ALL"."PO_LINE_ID"))
- INDEX_RS_ASC(@"SEL$A731BD80" "PO_LINE_LOCATIONS_ALL"@"SEL$8" ("PO_LINE_LOCATIONS_ALL"."LINE_LOCATION_ID"))
- BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$96467BBE" "PO_LINE_LOCATIONS_ALL"@"SEL$11")
- INDEX_RS_ASC(@"SEL$96467BBE" "PO_LINE_LOCATIONS_ALL"@"SEL$11" ("PO_LINE_LOCATIONS_ALL"."PO_LINE_ID"
- "PO_LINE_LOCATIONS_ALL"."SHIPMENT_TYPE"))
- BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$03235BA3" "PO_LINE_LOCATIONS_ALL"@"SEL$14")
- INDEX_RS_ASC(@"SEL$03235BA3" "PO_LINE_LOCATIONS_ALL"@"SEL$14" ("PO_LINE_LOCATIONS_ALL"."PO_HEADER_ID"
- "PO_LINE_LOCATIONS_ALL"."PO_RELEASE_ID"))
- BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$45068F18" "PO_LINE_LOCATIONS_ALL"@"SEL$17")
- INDEX_RS_ASC(@"SEL$45068F18" "PO_LINE_LOCATIONS_ALL"@"SEL$17" ("PO_LINE_LOCATIONS_ALL"."PO_RELEASE_ID"))
- NLJ_BATCHING(@"SEL$AC90CD92" "PO_LINE_LOCATIONS_ALL"@"SEL$2")
- USE_NL(@"SEL$AC90CD92" "PO_LINE_LOCATIONS_ALL"@"SEL$2")
- LEADING(@"SEL$AC90CD92" "VW_NSO_1"@"SEL$AC90CD92" "PO_LINE_LOCATIONS_ALL"@"SEL$2")
- INDEX(@"SEL$AC90CD92" "PO_LINE_LOCATIONS_ALL"@"SEL$2" ("PO_LINE_LOCATIONS_ALL"."LINE_LOCATION_ID"))
- NO_ACCESS(@"SEL$AC90CD92" "VW_NSO_1"@"SEL$AC90CD92")
- OUTLINE(@"SEL$2")
- OUTLINE(@"SEL$1")
- MERGE(@"SEL$2" >"SEL$1")
- OUTLINE(@"SEL$F5BB74E1")
- OUTLINE(@"UPD$1")
- OUTLINE(@"SEL$17")
- OUTLINE(@"SEL$16")
- OUTLINE(@"SEL$14")
- OUTLINE(@"SEL$13")
- OUTLINE(@"SEL$11")
- OUTLINE(@"SEL$10")
- OUTLINE(@"SEL$8")
- OUTLINE(@"SEL$7")
- OUTLINE(@"SEL$5")
- OUTLINE(@"SEL$4")
- MERGE(@"SEL$F5BB74E1" >"UPD$1")
- OUTLINE(@"SEL$1DB62934")
- OUTLINE(@"SET$1")
- MERGE(@"SEL$17" >"SEL$16")
- OUTLINE(@"SEL$97CCBC9E")
- OUTLINE(@"SEL$15")
- MERGE(@"SEL$14" >"SEL$13")
- OUTLINE(@"SEL$1CF66C63")
- OUTLINE(@"SEL$12")
- MERGE(@"SEL$11" >"SEL$10")
- OUTLINE(@"SEL$285A8194")
- OUTLINE(@"SEL$9")
- MERGE(@"SEL$8" >"SEL$7")
- OUTLINE(@"SEL$8A3193DA")
- OUTLINE(@"SEL$6")
- MERGE(@"SEL$5" >"SEL$4")
- OUTLINE(@"SEL$7286615E")
- OUTLINE(@"SEL$3")
- UNNEST(@"SET$1" UNNEST_INNERJ_DISTINCT_VIEW)
- OUTLINE_LEAF(@"SEL$AC90CD92")
- OUTLINE_LEAF(@"SET$FCA7A018")
- MERGE(@"SEL$97CCBC9E" >"SEL$15")
- OUTLINE_LEAF(@"SEL$45068F18")
- MERGE(@"SEL$1CF66C63" >"SEL$12")
- OUTLINE_LEAF(@"SEL$03235BA3")
- MERGE(@"SEL$285A8194" >"SEL$9")
- OUTLINE_LEAF(@"SEL$96467BBE")
- MERGE(@"SEL$8A3193DA" >"SEL$6")
- OUTLINE_LEAF(@"SEL$A731BD80")
- MERGE(@"SEL$7286615E" >"SEL$3")
- OUTLINE_LEAF(@"SEL$C8360722")
- ALL_ROWS
- OPT_PARAM('_fast_full_scan_enabled' 'false')
- OPT_PARAM('_b_tree_bitmap_plans' 'false')
- DB_VERSION('19.1.0')
- OPTIMIZER_FEATURES_ENABLE('19.1.0')
- IGNORE_OPTIM_EMBEDDED_HINTS
- END_OUTLINE_DATA
- */
- Predicate Information (identified by operation id):
- ---------------------------------------------------
- 7 - filter(:B2=:B1)
- 8 - filter("ORG_ID"=TO_NUMBER(SYS_CONTEXT('multi_org2','current_org_id')))
- 9 - access("LINE_LOCATION_ID"=TO_NUMBER(:B3))
- 10 - filter(:B2=:B4)
- 11 - filter("ORG_ID"=TO_NUMBER(SYS_CONTEXT('multi_org2','current_org_id')))
- 12 - access("PO_LINE_ID"=TO_NUMBER(:B3))
- 13 - filter(:B2=:B5 AND :B7<>:B6)
- 14 - filter("ORG_ID"=TO_NUMBER(SYS_CONTEXT('multi_org2','current_org_id')))
- 15 - access("PO_HEADER_ID"=TO_NUMBER(:B3))
- 16 - filter(:B2=:B5 AND :B7=:B6)
- 17 - filter("ORG_ID"=TO_NUMBER(SYS_CONTEXT('multi_org2','current_org_id')))
- 18 - access("PO_RELEASE_ID"=TO_NUMBER(:B3))
- 19 - access("LINE_LOCATION_ID"="LINE_LOCATION_ID")
- 20 - filter("SECONDARY_UNIT_OF_MEASURE" IS NOT NULL AND NVL("CANCEL_FLAG",'N')='I' AND
- "ORG_ID"=TO_NUMBER(SYS_CONTEXT('multi_org2','current_org_id')) AND NVL("CLOSED_CODE",'OPEN')<>'FINALLY
- CLOSED')
- 21 - filter("ORG_ID"=TO_NUMBER(SYS_CONTEXT('multi_org2','current_org_id')))
- 22 - access("PO_LINE_ID"=:B1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement