Re: Tuning large aggregation query

From: Thomas Kellerer <thomas.kellerer@xxxxxxxxxx>
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 08 Apr 2014 07:44:18 +0200

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
 
--
//www.freelists.org/webpage/oracle-l

Follow-Ups:
- Re: Tuning large aggregation query
  - From: Sidney Chen

References:
- Tuning large aggregation query
  - From: Thomas Kellerer
- Re: Tuning large aggregation query
  - From: Rumpi Gravenstein
- Re: Tuning large aggregation query
  - From: Sidney

Other related posts:

» Tuning large aggregation query- Thomas Kellerer
» Re: Tuning large aggregation query- Rumpi Gravenstein
» Re: Tuning large aggregation query- Sidney
» RE: Tuning large aggregation query- Jonathan Lewis
» RE: Tuning large aggregation query- Kenneth Naim
» RE: Tuning large aggregation query- Jonathan Lewis
» Re: Tuning large aggregation query- Mohamed Houri
» RE: Tuning large aggregation query- Jonathan Lewis
» RE: Tuning large aggregation query- Mark W. Farnham
» Re: Tuning large aggregation query- Martin Berger
» Re: Tuning large aggregation query- Thomas Kellerer
» Re: Tuning large aggregation query- Thomas Kellerer
» Re: Tuning large aggregation query - Thomas Kellerer
» Re: Tuning large aggregation query- Sidney Chen
» RE: Tuning large aggregation query- Jonathan Lewis