Increasing number of processes

I have Oracle 8.1.6 under Solaris 8.0. I need to increase number of processes so more user can log into the database. What other intialization parameters do I need to set in order to increase the value for processes parameter? There has to be some memory implications by increasing the value of processs.

    Requires Free Membership to View

    Login

You can increase the PROCESSES parameter in your INIT.ORA and bounce the database. The default values for SESSIONS and TRANSACTIONS are derived from this value. If you manually set these in your INIT.ORA as well, then you may have to adjust these values accordingly.

The initial effect of configuring your instance for more processes is pretty negligable on the overall memory consumption. The SGA does need a little more memory to handle these additional processes. The biggest difference will be in the working areas that these processes need in memory, defined by parameters such as SORT_AREA_SIZE and HASH_AREA_SIZE. Keep in mind that each session can consume this additional memory. So it is the database sessions that can increase your memory usage by increasing those number of sessions.

This was first published in October 2003

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top