Re: "10053" for Exadata smart table scan?
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 18 Sep 2017 20:31:36 -0400
Message-ID: <10d611eb-1624-8a35-965d-5e1d282801f7_at_gmail.com>
Date: Mon, 18 Sep 2017 20:31:36 -0400
Message-ID: <10d611eb-1624-8a35-965d-5e1d282801f7_at_gmail.com>
Dave, did you re-run system statistics? Also, if it's 12.1, do you have
adaptive optimization turned on? If your adaptive optimization is on,
you can have optimizer switching from hash join to nested loops.
On 09/18/2017 07:21 PM, Dave Herring wrote:
> VLOT is 1024 on both X-4 and X-6. I'll need to dive deeper into the
> middle of Frits' blog that hits this situation but what's odd is the
> change between X-4 and X-6 (and/or 11gR2 and 12cR1), possibly a change
> in comparing size thresholds for the object.
>
> Dave
--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 19 2017 - 02:31:36 CEST