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

    AIX RBMS 10g and 11g Installation guide

    653835
      Hi

      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,

      Thanks.

      Regards,
      Hub
        • 1. Re: AIX RBMS 10g and 11g Installation guide
          Cjmurray-Oracle
          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:

          default:
          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.