Re: 12.1.0.2 ADG Reading 1 block at a time? (TEMP / V$SORT_Segment)

On Tue, Jan 21, 2020 at 7:02 PM Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:

> So we use an ADG standby db for reporting and we've got some problem SQLs
> that I'm putzing around with because they work fine in all our other
> non-standby databases.
>

Same plan as on the non-standbys? Same system parameters? My best guess is that the sorts are happening in memory elsewhere and on disk on the ADG databases. May not necessarily be an issue with the temp tablespace or ADG specifically.

Andy K

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