AIX

 View Only

Oracle tuning

  • 1.  Oracle tuning

    Posted Fri July 19, 2024 05:33 AM

    Good morning,

    Following the POWER VUG Oracle presentation a couple of months ago, we did a bit of testing on two settings mentioned in the presentation, io_latency and j2_nPagesPerRBNACluster.

    Surprisingly, especially for the latter, both seems to slightly slow down batch processing. I applied the RBNA setting to all Oracle filesystems, but maybe some are more suited than others. 

    Has anyone had more success with this?

    Regards,

    Henrik Morsing



    ------------------------------
    Henrik Morsing
    ------------------------------