Please find a recent update here:
Last week I did post this entry with a strong recommendation to disable _rowsets_enabled in Oracle Database 220.127.116.11:
- Nov 10, 2015:
Switch off _rowsets_enabled in Oracle Database 12c
Today I can give you an update, more insight information and better workarounds.
Credits go to our DWH and Optimizer people (thanks to Hermann, Angela, Nigel and Mohammed).
When is the problem happening?
When a hash join operation receives rowsets from its right input but then produces one row at a time as output. This explains …Continue reading...