AIX

 View Only

  • 1.  Oracle19d on AIX7.2

    IBM Champion
    Posted Thu February 09, 2023 01:34 PM

    I am currently having challenges with our Oracle19c database running on IBM AIX7.2 TL5. I would like to know what parameters that need to be tuned to ensure we have good performance.

    We are using GPFS (Spectrum Scale) as the file systems also. Are there GPFS parameters that need to be tuned for a file system of 20TB in size.

    Thank you.

    Wole



    ------------------------------
    Olawole Adetayo
    ------------------------------


  • 2.  RE: Oracle19d on AIX7.2

    IBM Champion
    Posted Fri February 10, 2023 01:24 AM

    Hi Olawole,

    My recommendation is that open a Support case to IBM & ask via that guidance from IBM Montpellier Oracle team (Francois Martin & co) ; They do this (Oracle tuning on Power)  for their daily work and are extremely best in their class.

    They can provide you with Best Practises tuning guide (AIX, HW, kernel, Oracle db etc) + also most probably can guide you to some GPFS /Spectrum Scale expert who can say about tuning that part on Oracle usage too..

    (GPFS requires "slightly" different tuning depending on the workload which U R running on top of that..)

    Br,

    tommi



    ------------------------------
    Tommi Sihvo, Lead Service Architect
    Tietoevry, Compute Services
    email tommi.sihvo@tietoevry.com mobile +358 (0)40 5180 Finland
    ------------------------------

    Original Message


  • 3.  RE: Oracle19d on AIX7.2

    IBM Champion
    Posted Fri February 10, 2023 03:20 AM

    Hello Olawole,

    try to look at https://www.ibm.com/support/pages/power-systems-virtual-user-group. There are presentations regarding Best practices for Oracle on AIX.



    ------------------------------
    Andrey Klyachkin

    https://www.power-devops.com
    ------------------------------

    Original Message


  • 4.  RE: Oracle19d on AIX7.2

    IBM Champion
    Posted Mon February 13, 2023 04:31 AM

    Thanks All

     

    Kind regards

     

    Wole ADETAYO

    Group Technology Operations

    Head, Technology Infrastructure Operations

    Tel: +233302211104 Mobile:+233245864383

    VOIP: 8481186

    e-mail: wadetayo@ecobank.com

     

     

     

    Follow us 

    EPROCESS INTERNATIONAL SA

    2 Morocco Lane, Off Independence Avenue, Ministerial Area, Accra.

    P. O. Box AN 16746 Accra, Ghana
    ecobank.com

    Help save paper and consider our environment - do you need to print this email?

     

     




    Original Message


  • 5.  RE: Oracle19d on AIX7.2

    Posted Mon February 13, 2023 05:29 PM

    Olawole,

    I'd suggest to start with Oracle on AIX master document you can find here: 

    https://www.ibm.com/support/pages/node/6825029

    In that document there are also several references to other publications of potential interest.

    On Oracle MOS maybe have a look at: 
    IBM Spectrum Scale and Oracle RDBMS RAC (Doc ID 2587696.1)


    ------------------------------
    Ralf Schmidt-Dannert
    ------------------------------

    Original Message


  • 6.  RE: Oracle19d on AIX7.2

    Posted Mon February 13, 2023 12:50 AM
    Hello Wole!

    I seem to recall Oracle having a specific document for parameters such as the ones you look for, but they come from Oracle and not from IBM.  Try searching for an "Installation Guide on IBM AIX" on Oracle's website.  Also, are you sure it's Oracle DB 19D?  I believe 19C is the latest one available.

    Regards,
    Carlo Castillo



    Original Message


  • 7.  RE: Oracle19d on AIX7.2

    Posted Mon February 13, 2023 10:03 AM
    Edited by SANKET RATHI Tue February 14, 2023 04:06 AM

    HI Olawole, 

    You can also reach out to your local System seller and local Lab services team that can help you as well? 

    Are you based in the USA?

    If you run on an Enterprise Power server (e.g. 950, 980 or 1050, 1080) you might have still some Expert assist Unit (ex Cloud points) to be used to do such an analysis.

    Having AWR of Oracle (need Oracle diagnostic pack), it is possible to find all the TOP 5 and figure out where exactly the issue is and well as several hints on the SQL statements. Combine with NMOM you will have several hints where exactly issues. 

    Kind regard,

    Hubert



    ------------------------------
    Hubert Savio
    ------------------------------

    Original Message