SQL_ID 17wx85qmafgrn, child number 1 ------------------------------------- SELECT /*+ gather_plan_statistics */ /* grsdf */ reference_id FROM stpdoc_entry_table WHERE fc_id = :"SYS_B_0" AND doc_parent_id IN ( SELECT doc.doc_parent_id FROM stpdoc_entry_table doc LEFT JOIN dlv_cash_dbf dlv ON dlv.m_reference = doc.doc_parent_id WHERE dlv.m_reference IS NULL AND doc.fc_id = :"SYS_B_1" ) AND ( xmlflow_status IN ( SELECT b.xmlflow_status FROM mwp_tmp_statuses_2b_purged b ) OR ( xmlflow_status = :"SYS_B_2" AND xmlflow_error_type = :"SYS_B_3" ) ) ORDER BY reference_id Plan hash value: 233192241 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Starts | E-Rows | Cost (%CPU)| A-Rows | A-Time | Buffers | OMem | 1Mem | Used-Mem | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | | 3363K(100)| 0 |00:00:10.97 | 854K| | | | | 1 | SORT ORDER BY | | 1 | 7 | 3363K (1)| 0 |00:00:10.97 | 854K| 1024 | 1024 | | |* 2 | FILTER | | 1 | | | 0 |00:00:10.97 | 854K| | | | |* 3 | HASH JOIN RIGHT SEMI | | 1 | 3209K| 123K (1)| 456K|00:00:08.29 | 854K| 21M| 7237K| 21M (0)| | 4 | VIEW | VW_NSO_1 | 1 | 32092 | 28159 (1)| 456K|00:00:01.60 | 98488 | | | | | 5 | NESTED LOOPS ANTI | | 1 | 32092 | 28159 (1)| 456K|00:00:01.56 | 98488 | | | | |* 6 | VIEW | index$_join$_002 | 1 | 3209K| 28137 (1)| 2754K|00:00:04.27 | 40548 | | | | |* 7 | HASH JOIN | | 1 | | | 2754K|00:00:03.67 | 40548 | 154M| 17M| 133M (0)| |* 8 | INDEX RANGE SCAN | STPDOC_ENTRY_NDX_FC_ID | 1 | 3209K| 836 (1)| 2754K|00:00:00.41 | 5766 | | | | | 9 | INDEX FAST FULL SCAN | STPDOC_ENTRY_TABLE_I6 | 1 | 3209K| 4376 (1)| 13M|00:00:02.42 | 34782 | | | | |* 10 | INDEX UNIQUE SCAN | DLV_CASH_ND0 | 2230K| 1882K| 1 (0)| 2230K|00:00:00.78 | 57940 | | | | | 11 | TABLE ACCESS BY INDEX ROWID BATCHED| STPDOC_ENTRY_TABLE | 1 | 3209K| 95168 (1)| 2754K|00:00:03.50 | 755K| | | | |* 12 | INDEX RANGE SCAN | STPDOC_ENTRY_NDX_FC_ID | 1 | 3209K| 835 (0)| 2754K|00:00:00.53 | 5766 | | | | |* 13 | INDEX RANGE SCAN | MWP_TMP_STATUSES_2B_PURGED_I1 | 1 | 1 | 1 (0)| 0 |00:00:00.01 | 1 | | | | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Peeked Binds (identified by position): -------------------------------------- 1 - :1 (NUMBER): 0 2 - :2 (NUMBER): 0 3 - (VARCHAR2(30), CSID=873): '~SYS_ERROR~' 4 - (VARCHAR2(30), CSID=873): 'D' Predicate Information (identified by operation id): --------------------------------------------------- 2 - filter((("XMLFLOW_STATUS"=:SYS_B_2 AND "XMLFLOW_ERROR_TYPE"=:SYS_B_3) OR IS NOT NULL)) 3 - access("DOC_PARENT_ID"="DOC_PARENT_ID") 6 - filter("DOC"."FC_ID"=:SYS_B_1) 7 - access(ROWID=ROWID) 8 - access("DOC"."FC_ID"=:SYS_B_1) 10 - access("DLV"."M_REFERENCE"="DOC"."DOC_PARENT_ID") 12 - access("FC_ID"=:SYS_B_0) 13 - access("B"."XMLFLOW_STATUS"=:B1) Note ----- - dynamic statistics used: dynamic sampling (level=2)