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: @OracleSK
Eriovaldo Andrietta <ecandrietta@xxxxxxxxx> 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