Better index stats on oracle 19C : approx_count_distinct

Until oracle 12.2 index statistics are still sample-based using an iterative method when ESTIMATE_PERCENT  is set to AUTO_SAMPLE_SIZE . Recently when analyzing a performance problem in one of our 19C databases i discovered an interesting but undocumented change (as i’m aware off).

Cool ORACLE feature that i would love to have on AWS : More predefined security recipe

Although The AWS cloud offers the wider range of security services than the other providers and the highest level of customization of any vendor, in my opinion something is still missing.

The ORACLE cloud compared to AWS come with many predefined security recipe which allow more automated enforcement of security practices with far less configuration . For inexperienced user this can be very helpful for enhancing the overall security without requiring additional manual effort and reducing human error.

Cool ORACLE feature that would be welcome also on AWS : Compartement

I will start a series of short blogs posts showing some cool Oracle cloud feature that i would love to see also on AWS Cloud. Of course this is my point of views , every one can disagree :p

In this first blog post we will start by looking at what is known on the oracle cloud as “Compartement”