PLAN_TABLE_OUTPUT
SQL_ID  fy3fdv8t058jp, child number 1
-------------------------------------
select distinct seq_id, c001,c002,c003,to_char(to_date(c004,'dd-mm-yyyy 
hh24:mi:ss'),'DD.MM.YYYY') ñ004,c005    from       test_col_2    where  
     SEQ_ID not in (select SEQ_ID    from       
test_col_2,fpsp_trunc@pap    where       FIO like 
replace(UPPER(TRIM(c001)||' '||TRIM(c002)||' 
'||TRIM(c003)),'¨','Å')||'%'    and       DTBIRTH= 
to_char(to_date(c004,'dd-mm-yyyy hh24:mi:ss'),'YYYY-MM-DD')    and      
  (          :P2_SEGM is null or instr(:P2_SEGM||',', N_SEGM||',')>0    
    )    and         (          :P2_BEG is null or 
ENT_DATE>to_date(:P2_BEG)         )     and         (          :P2_END 
is null or ENT_DATE<to_date(:P2_END)         ) )
 
Plan hash value: 609694383
 
------------------------------------------------------------------------------------------------------------
| Id  | Operation             | Name       | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     | Inst   |IN-OUT|
------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT      |            |       |       |       | 15534 (100)|          |        |      |
|   1 |  HASH UNIQUE          |            | 44263 |  3803K|  4176K| 15534   (5)| 00:00:01 |        |      |
|*  2 |   HASH JOIN RIGHT ANTI|            | 44263 |  3803K|       | 12145   (6)| 00:00:01 |        |      |
|   3 |    VIEW               | VW_NSO_1   |    60 |   300 |       | 10096   (7)| 00:00:01 |        |      |
|*  4 |     HASH JOIN         |            |    60 |  9660 |       | 10096   (7)| 00:00:01 |        |      |
|   5 |      REMOTE           | FPSP_TRUNC |   522 | 55854 |       |  8048   (8)| 00:00:01 | PAP    | R->S |
|   6 |      TABLE ACCESS FULL| TEST_COL_2 | 44323 |  2337K|       |  2047   (1)| 00:00:01 |        |      |
|   7 |    TABLE ACCESS FULL  | TEST_COL_2 | 44323 |  3592K|       |  2047   (1)| 00:00:01 |        |      |
------------------------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   2 - access("SEQ_ID"="SEQ_ID")
   4 - access("DTBIRTH"=TO_CHAR(TO_DATE("C004",'dd-mm-yyyy hh24:mi:ss'),'YYYY-MM-DD'))
       filter("FIO" LIKE REPLACE(UPPER(TRIM("C001")||' '||TRIM("C002")||' 
              '||TRIM("C003")),'¨','Å')||'%')
 
Remote SQL Information (identified by operation id):
----------------------------------------------------
 
   5 - SELECT "FIO","DTBIRTH","N_SEGM","ENT_DATE" FROM "FPSP_TRUNC" "FPSP_TRUNC" WHERE (:1 IS NULL 
       OR INSTR(:2,"N_SEGM"||',')>0) AND (:3 IS NULL OR "ENT_DATE">:4) AND (:5 IS NULL OR "ENT_DATE"<:6) 
       (accessing 'PAP' )