1 Reply Latest reply on May 4, 2009 6:17 PM by Cjmurray-Oracle

    AIX RBMS 10g and 11g Installation guide


      Regarding the AIX documentation RBMS 10g and 11g Installation guide I'm missing the maxuproc default values, am i the only one?

      IBM says that for Oracle the best practice value that is 4096.

      lsattr -E -l sys0 -a maxuproc -F value

      Had a lot of trouble with a too low value, it was set to only 128....

      Please support my request guys,


        • 1. Re: AIX RBMS 10g and 11g Installation guide
          The only reference to maxuprox I could find in the Oracle Database 11gR1 doc library was in Section 2.8.3 ("Configuring Shell Limits") in "Oracle Clusterware Installation Guide 11g Release 1 (11.1) for AIX Based Systems". Below is a plain-text version of that section. I know it doesn't address exactly what you asked, but is that information sufficient?

          2.8.3 Configuring Shell Limits

          To improve the performance of the software, you must increase the following shell limits:
          Shell Limit      Item in limits.conf      Hard Limit
          Maximum number of open file descriptors      nofile      65536
          Maximum number of processes available to a single user      maxuproc      16384

          To increase the shell limits:

          1. Add the following lines to the /etc/security/limits file:

          fsize = -1
          core = -1
          cpu = -1
          data = 512000
          rss = 512000
          stack = 512000
          nofiles = 2000

          2. Enter the following command to list the current setting for the maximum number of process allowed by the Oracle software user:

          /etc/lsattr -E -l sys0 -a maxuproc

          If necessary, change the maxuproc setting using the following command:

          /etc/chdev -l sys0 -a maxuproc = 16384

          3. Repeat this procedure on all other nodes in the cluster.
          1 person found this helpful