Re: Increased PGA requirements for SORTs in 19c?
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Fri, 20 Nov 2020 15:28:01 +0300
Message-ID: <CAOVevU4uSXQa5axLmD6xDoJf1SxP9LMOqQp7JRwOzRi9C0YoCg_at_mail.gmail.com>
Date: Fri, 20 Nov 2020 15:28:01 +0300
Message-ID: <CAOVevU4uSXQa5axLmD6xDoJf1SxP9LMOqQp7JRwOzRi9C0YoCg_at_mail.gmail.com>
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-lReceived on Fri Nov 20 2020 - 13:28:01 CET