Re: Interesting Issue related to sql result

Hello Eriovaldo,
unfortunately you have not provided either your exact Oracle version or the full execution plan (especially column projection information) ... so this is a wild guess but as this wrong result set seems to be related to the FETCH data volume - please just try the following:

SQL> alter session set "_rowsets_enabled"=FALSE;

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: http://www.soocs.de
Twitter: _at_OracleSK

> Eriovaldo Andrietta <ecandrietta_at_gmail.com> hat am 5. April 2018 um 21:25 geschrieben:
>
> HI,
>  
> Does anyone knows ​what happens in this cenary :
>  
> I have a query like this.
>  
> SELECT /*+   parallel (area_control,6)                                                           
>              parallel (lot_f,6)
>         */
>              [lot_f.id](http://lot_f.id),
>              lot_f.lot_id
>         FROM op_serving_area_f       area_control,
>              lot_f                   lot_f,
>              lot,
>              addr_blocked_cfg,
>              op_serving_area         area_c,
>              op_serving_area_wcenter
>        WHERE sdo_relate(lot_f.geometry,
>                         area_control.geometry,
>                         'mask=INSIDE+COVEREDBY') = 'TRUE'
>          AND SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(area_control.geometry,  0.001) = 'TRUE'
>          AND area_control.op_serving_area_id = [area_c.id](http://area_c.id)
>          AND area_c.area_type = 2
>          AND [lot.id](http://lot.id) = lot_f.lot_id
>          AND lot.addr_blocked_cfg_id = [addr_blocked_cfg.id](http://addr_blocked_cfg.id)(+)
>          AND op_serving_area_wcenter.op_serving_area_id = [area_c.id](http://area_c.id)
>          and lot_f.lot_id = 218692
> /
>  
> When I run it as is above it returns to me the line :
>
>
> 5679907 218692
>
>
> ​If I change it in order to return all lines, ​ changing only it :
>
>
> --         and lot_f.lot_id = 218692
>
> ​The line does not return in the result.
>
> Any experience with cenary like this ?
>
> Regards
> Eriovaldo

--
http://www.freelists.org/webpage/oracle-l