Re: Group by wrong results?

On 2018/08/08 13:33, Daniel Fink wrote:

> The 2nd query I posted is returning the data I want (max number of sessions per minute, not a total count of sessions per minute). I pulled the queries apart and checked the data output.

It's interesting that:

ALTER SYSTEM SET OPTIMIZER_FEATURES_ENABLE='12.1.0.1' SCOPE=BOTH; ...has the query returning the correct results, as inferred by Jonathan's blog post linked in a previous response.

I'm getting the same incorrect grouping as you with my 12.1.0.2 DB, and this setting appears to be a workaround, although with the distinct possibility of other side-effects.

Rich

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