Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    21

    Unanswered: Changing "processes" parameter in the init.ora file...

    Hi All,

    I have a question regarding initialization parameters.

    I am running Oracle8i database on Redhat Linux.

    In the init.ora file, the small,medium and large values are mentioned in the comments for the "processes" parameter.

    For eg:

    This is how it appears in the init.ora file:

    #processes = 50 #small
    #processes = 100 #small
    #processes = 200 #small

    I wanted to know whether this is the set range or what.

    Can't I have 400 users using the database remotely and hence set the processes parameter to 400 + (# of background processes) ???


    If I can, can I change the parameter value while the database is still running ??

    It will be a great help if someone could answer my questions.

    Thanks,

    - Bikram.

  2. #2
    Join Date
    Aug 2003
    Location
    SW Ohio
    Posts
    198

    Re: Changing "processes" parameter in the init.ora file...

    Originally posted by bikramjeet77
    .....

    If I can, can I change the parameter value while the database is still running ??

    It will be a great help if someone could answer my questions.

    Thanks,

    - Bikram.
    As far as changing the parameters on a running database you need to look at a copy of the SQL 8i Reference. Look it up at http://otn.oracle.com/documentation/content.html. You'll probably need to register, but I think its free. Ninety percent of the parameters can be changed on a running database by doing an Alter System or Alter Database command. Any changes made in the init.ora do not take effect until the database is restarted.

    You'll have to check the documentation.
    Jim P.

    Supoorting Oracle, MSSQL7, Sybase 8, & Pervasive. Confusion Reigns

  3. #3
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    181
    Hi,

    You will have to bounce your database to take the new processes value.

    Please note however that you have the correct oracle recommended semephore values in /etc/system file - these can limit the amount of processes.

    Rgs,
    Breen.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •