Re: Increased PGA requirements for SORTs in 19c?

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_at_gmail.com> 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
>
>>

--
http://www.freelists.org/webpage/oracle-l