Wrong results possible from the result of a non-distinct aggregation
with a group by (such as sum(col)) when HASH GROUP BY is used.
The wrong results show as missing values from the aggregate.
Increase the memory used by hash group by
Disable the use of hash group by
eg: set optimizer_features_enable to "10.1.0"
set "_gby_hash_aggregation_enabled" to FALSE.
Versions confirmed as being affected 10.2.0.1
This issue is fixed in 10.2.0.3 (Server Patch Set)
11g (Future version)
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24383181/viewspace-714549/，如需转载，请注明出处，否则将追究法律责任。