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@xxxxxxxxx> 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@xxxxxxxxx> wrote:create a baseline and this will end up consume considerable space in SYSAUX
Hi
Mladen, I told the customer that all SQL execute more than once will
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.
benefit, many years have passed since this oracle-l post it seems to me no
I only have seen a few people enabled this in production with no much
one set this in production yet. :-)
Thank you