Re: Using OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=TRUE in Production
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 4 Mar 2019 08:36:13 -0500
Message-ID: <91d2e5bc-c5b6-380c-dac7-685b3df7df3f_at_gmail.com>
Date: Mon, 4 Mar 2019 08:36:13 -0500
Message-ID: <91d2e5bc-c5b6-380c-dac7-685b3df7df3f_at_gmail.com>
Hi!
I would like Jonathan or Mark Farnham to weigh in on automatic baselines. I am not a DBA and have no database of my own.
Regards
On 3/4/19 7:22 AM, Andy Sayer wrote:
> We did it for the same reasons I suggested earlier
>
> General plan stability
> Easy to manipulate and test alternate plans
> Easier to get sign off on patching and upgrades
>
> This has been in place for about 2 years now and we have seen a huge
> reduction in performance issues and time required to address a
> performance issue
>
> Thanks,
> Andy
> Hi --
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 04 2019 - 14:36:13 CET