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:

> 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-l

Received on Tue Apr 08 2014 - 07:44:18 CEST

This message: [ Message body ]
Next message: Toon Koppelaars: "Re: Separate Schemas for Data and Application?"
Previous message: Chitale, Hemant K: "RE: Separate Schemas for Data and Application?"
In reply to: Sidney: "Re: Tuning large aggregation query"
Next in thread: Sidney Chen: "Re: Tuning large aggregation query"
Reply: Sidney Chen: "Re: Tuning large aggregation query"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message