DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Maximum limit of the Process parameter

  1. 01-28-2003, 09:03 AM #1
    santhosh4u
    santhosh4u is offline Junior Member
    Join Date
    Apr 2002
    Posts
    2

    Maximum limit of the Process parameter

    What is the Maximum value which can be set for a process parameter in init.ora assuming the OS supports any value.
    Thanks

    Santhosh
    Reply With Quote Reply With Quote
  2. 01-28-2003, 09:49 AM #2
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    I think it's 32,000 per instance (9i)

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Reply With Quote Reply With Quote
  3. 01-28-2003, 02:08 PM #3
    sgodbole
    sgodbole is offline Junior Member
    Join Date
    Jan 2003
    Posts
    78
    Actually, the parameter name is PROCESSES and it is OS dependent. Refer your operating system specific Oracle documentation for the range of values. Default value of this parameter is derived from PARALLEL_MAX_SERVERS.
    HTH.
    Shripad Godbole
    OCP DBA (8,8i,9i)

    "Let's document it and call it a feature."
    Reply With Quote Reply With Quote
  4. 01-28-2003, 06:02 PM #4
    sreddy's Avatar
    sreddy
    sreddy is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    Re: Maximum limit of the Process parameter

    Originally posted by santhosh4u
    What is the Maximum value which can be set for a process parameter in init.ora assuming the OS supports any value.
    Thanks

    Santhosh
    Not just OS supports, OS should be having enough hardware to support. It depends on your shared memory and semaphores.
    Reddy,Sam
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width