Tuning Advice
From: Sheehan, Jeremy <JEREMY.SHEEHAN_at_fpl.com>
Date: Fri, 27 Apr 2018 15:50:35 +0000
Message-ID: <bb295ca05ebc4bfe9f016d0b776793c0_at_fpl.com>
Hello Gurus,
Date: Fri, 27 Apr 2018 15:50:35 +0000
Message-ID: <bb295ca05ebc4bfe9f016d0b776793c0_at_fpl.com>
Hello Gurus,
Oracle 12.1.0.2
Any suggestion on how I can have the optimizer not use a specific execution plan or any session level parameters that would have it use a different execution plan?
Thanks in advance!
Jeremy
AIX 7.1
I have a query that runs fairly well. Takes about 8 minutes to run, nothing terrible about it (no huge FTS, joins seem to be in place correctly). When I try to do an insert into TABLE as SELECT, it picks a completely different execution plan and never finishes. The really odd thing is that it works great when using CTAS or initial creation of a MV.
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 27 2018 - 17:50:35 CEST