Re: Tuning large aggregation query
From: Thomas Kellerer <thomas.kellerer_at_mgm-tp.com>
Date: Tue, 08 Apr 2014 07:44:18 +0200
Message-ID: <53438CB2.3070305_at_mgm-tp.com>
Sidney, 04.04.2014 15:31:
Date: Tue, 08 Apr 2014 07:44:18 +0200
Message-ID: <53438CB2.3070305_at_mgm-tp.com>
Sidney, 04.04.2014 15:31:
> have you try Workarea_size_policy to manual and increase the hash_area_size/sort_area_size.
Yes I tried. I increased both up to 512MB but unfortunately without any change.
Regards
Thomas
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 08 2014 - 07:44:18 CEST