AIX

AIX

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

 View Only

  • 1.  Runqueue in TOPAS

    Posted Tue April 10, 2012 03:53 PM

    Originally posted by: aaa11


    Hi,

    Iam new one to AIX.Can anyone explain about runqueue in TOPAS.
    Today we faced db hang issue at that time run queue value is 1400.

    Thanks & Regards,
    VN


  • 2.  Re: Runqueue in TOPAS

    Posted Tue April 10, 2012 04:10 PM

    Originally posted by: alethad


    Runqueue is basically the number of processes waiting to be processed. there's plenty of docs online that will explain this further.

    I will tell you that runqueue should not even be in double digits for any length of time. I'm surprised you haven't some other serious issues.

    What DB are you using? Have you tuned your AIX OS to the DB? Oracle has a whole document regarding tuning with AIX. so do other DB's.

    You've got to continue to grow, or you're just like last night's cornbread -- stale & dry Loretta Lynn alethad


  • 3.  Re: Runqueue in TOPAS

    Posted Tue April 10, 2012 04:27 PM

    Originally posted by: aaa11


    Hi,
    we using oracle 11.1.


  • 4.  Re: Runqueue in TOPAS

    Posted Tue April 10, 2012 04:40 PM

    Originally posted by: alethad


    Have you tuned the OS with Oracle yet?

    Go download this IBM White paper and keep it on hand for future use also. Page 32 will tell you what parameter changes are recommended. Read the document first so you can understand what you're doing. Some of the parameters require a reboot.

    Also you will need to get with your DBA and have them make any necessary changes to Oracle itself.
    http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP100883

    Good Luck

    You've got to continue to grow, or you're just like last night's cornbread -- stale & dry Loretta Lynn alethad


Related Content