Re: 12.1.0.2 ADG Reading 1 block at a time? (TEMP / V$SORT_Segment)
- From: Andy Klock <andy@xxxxxxxxxxxxxxx>
- To: Chris Taylor <christopherdtaylor1994@xxxxxxxxx>
- Date: Wed, 22 Jan 2020 08:48:38 -0500
On Tue, Jan 21, 2020 at 7:02 PM Chris Taylor <
christopherdtaylor1994@xxxxxxxxx> 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
Other related posts:
