OPERATION

OBJECT_NAME

OPTIONS

PARTITION_START

PARTITION_STOP

PARTITION_ID

CARDINALITY

COST

MERGE STATEMENT

70111

27632320

MERGE

SRC_SIP_GEN_OSP.TPT_CLAUSOLA

VIEW

HASH JOIN

OUTER

70111

27632320

Access Predicates

AND

TRG.PROGR_SUB(+)=from$_subquery$_007.PROGR_SUB

TRG.PROGR(+)=from$_subquery$_007.PROGR

TRG.REVKEY(+)=from$_subquery$_007.REVKEY

TRG.TMS_INSERIMENTO(+)=INTERNAL_FUNCTION(from$_subquery$_007.TMS_INSERIMENTO)

TRG.COD_COMPON(+)=from$_subquery$_007.COD_COMPON

TRG.NUM_POLIZZA(+)=from$_subquery$_007.NUM_POLIZZA

VIEW

70111

1460521

Filter Predicates

RK=1

WINDOW

SORT PUSHED RANK

70111

1460521

Filter Predicates

ROW_NUMBER() OVER ( PARTITION BY NLSSORT(INTERNAL_FUNCTION(NUM_POLIZZA),'nls_sort=''WEST_EUROPEAN'''),NLSSORT(INTERNAL_FUNCTION(COD_COMPON),'nls_sort=''WEST_EUROPEAN'''),NLSSORT(TMS_INSERIMENTO,'nls_sort=''WEST_EUROPEAN'''),REVKEY,PROGR,PROGR_SUB ORDER BY NLSSORT(POS,'nls_sort=''WEST_EUROPEAN''') DESC ,NLSSORT(OP_TS,'nls_sort=''WEST_EUROPEAN''') DESC )<=1

PARTITION RANGE

ALL

1048575

70111

1446059

TABLE ACCESS

SRC_SIP_GEN_OSP.EL_TPT_CLAUSOLA

STORAGE FULL

1048575

70111

1446059

Access Predicates

AND

TO_NUMBER(TO_CHAR(TO_TIMESTAMP(OP_TS,'YYYY-MM-DD HH24:MI:SS.FF6')+INTERVAL'+00 02:00:00' DAY(2) TO SECOND(0)+INTERVAL'+00 00:00:00' DAY(2) TO SECOND(0)+INTERVAL'+00 00:00:00.000000' DAY(2) TO SECOND(6),'YYYYMMDDHH24MISSFF6'))>=20220624201001000000

Filter Predicates

AND

TABLE ACCESS

SRC_SIP_GEN_OSP.TPT_CLAUSOLA

STORAGE FULL

789761431

13182197

Other XML

{info}

info type="nodeid/pflags"

7 17

info type="nodeid/pflags"

6 17

info type="db_version"

11.2.0.3

info type="parse_schema"

"GU_PRESIDIO_ADG"

info type="plan_hash"

3961524035

info type="plan_hash_2"

2759474175

{hint}

FULL(@"SEL$4" "EL_TPT_CLAUSOLA"@"SEL$4")

FULL(@"SEL$6" "EL_TPT_CLAUSOLA"@"SEL$6")

NO_ACCESS(@"SEL$5" "from$_subquery$_004"@"SEL$5")

USE_HASH(@"SEL$5428C7F1" "TRG"@"SEL$2")

LEADING(@"SEL$5428C7F1" "from$_subquery$_007"@"SEL$3" "TRG"@"SEL$2")

FULL(@"SEL$5428C7F1" "TRG"@"SEL$2")

NO_ACCESS(@"SEL$5428C7F1" "from$_subquery$_007"@"SEL$3")

USE_MERGE_CARTESIAN(@"MRG$1" "TRG"@"MRG$1")

USE_MERGE_CARTESIAN(@"MRG$1" "SRC"@"MRG$1")

LEADING(@"MRG$1" "from$_subquery$_010"@"MRG$1" "SRC"@"MRG$1" "TRG"@"MRG$1")

FULL(@"MRG$1" "TRG"@"MRG$1")

NO_ACCESS(@"MRG$1" "SRC"@"MRG$1")

NO_ACCESS(@"MRG$1" "from$_subquery$_010"@"MRG$1")

OUTLINE(@"SEL$3")

OUTLINE(@"SEL$2")

OUTLINE(@"SEL$1")

OUTLINE_LEAF(@"MRG$1")

OUTLINE_LEAF(@"SEL$5")

OUTLINE_LEAF(@"SEL$6")

MERGE(@"SEL$3")

MERGE(@"SEL$2")

OUTLINE_LEAF(@"SEL$5428C7F1")

OUTLINE_LEAF(@"SEL$4")

ALL_ROWS

OPT_PARAM('_b_tree_bitmap_plans' 'false')

DB_VERSION('11.2.0.3')

OPTIMIZER_FEATURES_ENABLE('11.2.0.3')

IGNORE_OPTIM_EMBEDDED_HINTS