Question about Processes/NPROC
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Question about Processes/NPROC

  1. #1
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586

    Question Question about Processes/NPROC

    I am just wondering. What is the relationshipship between NPROC and the Processes parameter? If the Processes Parameter in oracle 9i database on an HPUX is set to 1500 and the NPROC is set to 7200 can Oracle spawn/fork processes beyond 1500?

    Our beefy server stopped responding because i was nto able to spawn any more processes..we had to do a hard reboot.
    "High Salaries = Happiness = Project Success."

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    NPROC is the kernel parameter controlling maximum number of simultaneous processes for all "users". This should be 3 times the value of SEMMNS.

    What is the value of MAXUP?
    If the Processes Parameter in oracle 9i database on an HPUX is set to 1500 and the NPROC is set to 7200 can Oracle spawn/fork processes beyond 1500?
    No. Oracle can fork max of 1500 processes only.

    Tamil

  3. #3
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Thanks Tamil,

    the LOCAL=NO processes in Unix are shadow processes right? Since the Processes parameter in INIT.ORA is set to 1500 is there evern instance you can think off you might see over 1500 spawned shadow (LOCAL=NO) processes in Unix? I have implimented SQLNET.EXPIRE to cleanup dead connections?
    "High Salaries = Happiness = Project Success."

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    whats local=no got to do with processes? they are just people connecting remotely

  5. #5
    Join Date
    Feb 2003
    Posts
    85
    Leave him, this guy is just clueless

  6. #6
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Guru_heaven...i don't appreciate your words..It seems you dont have the professionalism required to work by an IT person. If you don't have any thing "INTELLIGENT" to say/add then please refrain from making any such statements. I can make similar statements to your previos posts as well but i dont want to lower my "standards" and bar myself from this site for arguing with a "JUNIOR" member I looked thru your posts and I dont see you adding any value to anyone's posts. Thats why you only have 73 posts..

    I see tamilselvan and davey23uk working really hard trying to help me get a better understanding about my current issue.

    Be well.
    "High Salaries = Happiness = Project Success."

  7. #7
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    How many instances are you running in the server?
    The number processes controlled within ORACLE is PROCESSES parameter in init.ora in each instance.

    As I said earlier UNIX OS has its own limitations (NPROC, SEMMNS, and MAXUP).

    Tamil

  8. #8
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Tamil, we are running two instances on this server. based on Oracle 9i kernel parm recommendations, the kernel parms are tuned optimally. What we are noticing is the seibel middle tier(s) spawing 400+ remote connections but not cleaning them up.
    "High Salaries = Happiness = Project Success."

  9. #9
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    then sort your application out if it is not closing connections

  10. #10
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Quote Originally Posted by jlakhani
    Tamil, we are running two instances on this server. based on Oracle 9i kernel parm recommendations, the kernel parms are tuned optimally. What we are noticing is the seibel middle tier(s) spawing 400+ remote connections but not cleaning them up.
    The Siebel app server uses connection pools. The POOLS (connections you see in DB server) are persistent. They will be reused as the users login into system. No need to worry. I am also using Siebel.

    Tamil

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