How do you setup the processes parameters in init.ora
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How do you setup the processes parameters in init.ora

  1. #1
    Join Date
    Nov 2003
    Posts
    3

    Question How do you setup the processes parameters in init.ora

    Hi,

    I have an E450 Sun Solaris box. It is 2 GB physical memory, and 4 CPUs.

    I set up 2 databases on this box. My question :
    How do I know the processes and sessions in both init files setup are right?

    I would like to bump these parameters as high as it could. SO system can support more concurrent sessions which means more users can connect to our DB at the same time. So I won't receive max session exceed this error.

    Thanks

    Stacy

  2. #2
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    Set to the number that you really need, LGWR needs to scan all processes to check if it is waiting to commit.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  3. #3
    Join Date
    Nov 2003
    Posts
    3
    Let's say:

    Set processes=1000
    session=1000

    in both init files.

    So how do I know the system distributes the resource efficiently?

    How do I check? I mean Unix kernel setting (memory segment as well as
    semophores)

    Thanks

    Stacy

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    I do not think resources are sufficient to set 1000 processes for that box. Increment it in multiples of 50 processes and monitor number of sessions in use (from v$session) and then go from there.

    You can give a thought to MTS architecture in place of dedicated server architecture if you need more number of seesions to handle your application requests.
    Reddy,Sam

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