AppWorx, Dollar Universe and Sysload Community

Automic Performance Issues with Oracle 12C R1 ?

  • 1.  Automic Performance Issues with Oracle 12C R1 ?

    Posted 08-05-2020 03:12 AM

    Dear Community,

    I just saw that other job schedulers are warning to Upgrade to Oracle 12 R1 because of performance issues with CLOBs.
    It seems that SecureFiles of Oracle 12 R1 are ignoring the setting to store CLOBS "in-row" when using SecureFiles and always store them out-of-row resulting in a 10 times slower performance.

    Reference: https://communities.bmc.com/groups/alderstone/blog/2018/06/27/oracle-12c-remedy-itsm-lob-performance-warning

    From Automic Perspective, are there any known issues regarding this?
    Are there any recommended methods/metrics to compare two environments with each other?