Re: Using OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=TRUE in Production

it is not so wonderful otherwise it would be on in 19c for all queries :-)

On Fri, May 10, 2019 at 3:32 AM Leng Burgess <lkaing_at_gmail.com> wrote:

> Sorry, just going through my mailbox so maybe replying to some old stuff...
>
> " I said if this was a wonderful feature it would be enabled by default,
> that makes him start to think.”
>
> There are a lot of recommended stuff that are not turned on by default.
> eg. CONTROLFILE AUTOBACKUP is OFF by default but Oracle always recommends
> ON.
>
> I guess they are NOT turned on by default as it requires a lot more
> thought.
>
> eg. If you backup archive logs every 10 minutes, you’d get a control file
> auto backup every 10 minutes too! On one environment I saw that the
> backupset for control file auto backups were much larger than any other
> backup sets!!
>
>
>
>
>
> > On 4 Mar 2019, at 6:53 pm, Ls Cheng <exriscer_at_gmail.com> wrote:
> >
> > Hi
> >
> > Mladen, I told the customer that all SQL execute more than once will
> create a baseline and this will end up consume considerable space in SYSAUX
> but he says he does not mind, then I said if this was a wonderful feature
> it would be enabled by default, that makes him start to think.
> >
> > I only have seen a few people enabled this in production with no much
> benefit, many years have passed since this oracle-l post it seems to me no
> one set this in production yet. :-)
> >
> >
> > Thank you
>

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