RE: _gby_hash_aggregation_enabledúlse
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: <jonathan@xxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 30 Nov 2007 11:30:16 -0700
Thanks Jonathan - I think you're right. I tried again and this time
added a comment to the second execution of the query and sure enough, it
did switch to SORT GROUP BY. Then I ran the original query again and it
continued to use the HASH GROUP BY so apparently the hidden parameter
won't prevent its use if it's already in the shared pool - it only
prevents it from being chosen at parse time.
By the way, the query I sent wasn't meant to generate a HASH GROUP BY
operation, it was meant to check the shared pool to see if there are
currently any plans loaded that are using the HASH GROUP BY.
Thanks again,
Brandon
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jonathan Lewis
Try repeating your test with a comment in the text to make the before
and after versions of the query look different.
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
