Add 10033 to that for reporting spills to disc, otherwise the 10032 will
only show you the final memory used during the last merge, and that could
be very deceptive.
Regards
Jonathan Lewis
On Fri, 20 Nov 2020 at 12:29, Sayan Malakshinov <xt.and.r@xxxxxxxxx> wrote:
Hi Mike,
That's not enough info for deep detailed analysis. Could you trace your
query with enabled trace events 10046 and 10032 (sort statistics) and
provide raw trace files, please? Or at least RTSM reports. You can also
analyze v$sql_workarea (v$sql_workarea_active)
Best regards,
Sayan Malakshinov
Oracle performance tuning expert
Oracle Database Developer Choice Award winner
Oracle ACE Associate
http://orasql.org