DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: max process exceeded

  1. #1
    Join Date
    Jun 2000
    Posts
    315
    process in init.ora is 200, and I got this ora-20 error say that max processes exceeded. What should I do? It's on NT.

  2. #2
    Join Date
    Aug 2000
    Location
    NJ
    Posts
    54
    Go to your init.ora parameter file and edit your processes = 200 to make it say 300.


    Geo.


  3. #3
    Join Date
    Aug 2000
    Location
    NJ
    Posts
    54
    soory i forgot to add that you ned to bounce the database for the change to take effect.


    Geo

  4. #4
    Join Date
    Jun 2000
    Posts
    315
    Thank you!

    I did so. What is the max number of this parameter, I mean process? How come the time I got error message, only 29 processes in the database, much less 200, which is the number I set in the init.ora file?

    Thank you!

    Lisa

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    What was the parameter did you check?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  6. #6
    Join Date
    Jun 2000
    Posts
    315
    The parameter in init.ora I changed from 200 to 300 is process.

  7. #7
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    That is correct, but my question was what how did you check how many processes were alive when you had quoted that 26 processes were active.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  8. #8
    I think you could also experience this if you don't have enough memory assigned to oracle to spawn another process, although I thought it checked this at instance startup.

  9. #9
    Join Date
    Jun 2001
    Posts
    193
    sambavan:

    can u tell me how to check the number?
    guru is on the way!!!!

  10. #10
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    You could use the following query to check the number of processes that had been defined to be the max

    select name, value from v$parameter where name in ('processes');

    you could use V$process view to check the active processes. You could use v$session to check the number of sessions. Sessions are dependent on processes limit by default, unless and other wise you explicitly define them.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

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


Click Here to Expand Forum to Full Width