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@xxxxxxxxx> 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