AIX

AIX

Connect with fellow AIX users and experts to gain knowledge, share insights, and solve problems.

 View Only

  • 1.  AIX 5L performance issue

    Posted Thu June 14, 2007 09:46 AM

    Originally posted by: SystemAdmin


    Hello,

    i have ibm p570 16-way system divided 4 DLPAR and 64Gb RAM...so one of my node
    Baan Erp+Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
    mntrba01_1 /#uname -a
    AIX mntrba01_1 3 5 00CAA7ED4C00
    mntrba01_1 /#oslevel -r
    5300-05
    i try to find out the correct VM settings especially minperm,maxperm,minfree,maxfree and the other important kernel settings?
    and want to optimize my server...


  • 2.  Re: AIX 5L performance issue

    Posted Thu June 14, 2007 12:54 PM

    Originally posted by: steevojb


    Hi There,

    For Oracle database server I would consider the following

    minperm% = "5"
    maxclient% = "90"
    maxperm% = "90"
    strict_maxclient = "1"
    lru_file_repage = "0"

    HTH

    Steve


  • 3.  Re: AIX 5L performance issue

    Posted Thu June 14, 2007 04:42 PM

    Originally posted by: SystemAdmin


    I have a similar system on p550 (2 CPU, 4 G memory) with BAAN 5 and Ora 10g R2. I try to learn more how to tune too. Of course these values vary on different system and based on SLA. But i want to know how you came out your values according to your system. Can you share the steps?


  • 4.  Re: AIX 5L performance issue

    Posted Thu June 14, 2007 08:55 PM

    Originally posted by: SystemAdmin


    Before you make any changes, make sure you have your old default settings.

    Personally, I would not change anything without the vendor's specifications. Pulling random max/min-perm numbers can have negative impacts on your system, and environment.

    Good luck.


  • 5.  Re: AIX 5L performance issue

    Posted Fri June 15, 2007 04:21 AM

    Originally posted by: niella


    The values Steve gave are not "random". You should use them on an RDBMS system i.e. when computational memory must be protected.

    The guideline says to use it when AVM is less than 75% of real memory.

    Regards,
    Niel


  • 6.  Re: AIX 5L performance issue

    Posted Fri June 15, 2007 07:10 AM

    Originally posted by: SystemAdmin


    How and where did you get these settings? Is there a document that specifies these tuning parameters?

    I have a system, non RDBMS, and its very CPU,memory, and I/O intensive, how would I tune that?


  • 7.  Re: AIX 5L performance issue

    Posted Fri June 15, 2007 07:53 AM

    Originally posted by: SystemAdmin


    You may want to che out this link in regard of memory tuning: http://www.ibm.com/developerworks/aix/library/au-aixoptimization-memtun1/index.html?ca=drs-
    The "new" way to set it is with just with 1 tunable "lru_file_repage", at least that's what they say.


  • 8.  Re: AIX 5L performance issue

    Posted Fri June 15, 2007 12:37 PM

    Originally posted by: SystemAdmin


    At the risk of sounding judgmental why do you believe you need to "optimize" your system? Is there anything wrong with the way it's performing now? If it ain't broke, don't fix it:-)

    Forgive me for saying so but you're attacking this exactly backwards. By asking about things as specific as minperm/maxperm you're starting with a solution. How do you know you're not solving the wrong problem?

    HTH

    Jim Lane


Related Content