Re: Using OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=TRUE in Production

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