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

Thread: No. of processes in init.ora

  1. 10-10-2003, 11:38 AM #1
    amit_ahuja
    amit_ahuja is offline Junior Member
    Join Date
    Jun 2001
    Location
    India
    Posts
    30

    No. of processes in init.ora

    Hi!
    I wanted to confirm one thing- how is No is of processes in init.ora linked with total no. of connections we can made through our application to the database. If we have this parameter set as 500, that means only around 490 users will be able to login in the application? or is there any other parameter also which is responsible for total no. of users connected with the database at a time?

    Waiting eagerly for the response...
    Rgds,
    Amit
    Reply With Quote Reply With Quote
  2. 10-10-2003, 11:54 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    sessions as well
    Reply With Quote Reply With Quote
  3. 10-10-2003, 11:59 AM #3
    Cookies
    Cookies is offline Member
    Join Date
    Oct 2002
    Posts
    182
    Originally posted by davey23uk
    sessions as well
    Is sessions only valid/used when you have DISPATCHERS/MTS set?

    I am not using MTS at the moment and it seems there is a process for every connection/session. Ok, maybe I am confused.
    - Cookies
    Reply With Quote Reply With Quote
  4. 10-10-2003, 01:33 PM #4
    bhallar
    bhallar is offline Member
    Join Date
    Jun 2001
    Location
    California
    Posts
    124
    "Sessions" will be effective only if u r using MTS.
    Reply With Quote Reply With Quote
  5. 10-10-2003, 02:54 PM #5
    amit_ahuja
    amit_ahuja is offline Junior Member
    Join Date
    Jun 2001
    Location
    India
    Posts
    30

    and if not implementing MTS....

    That means if we have processes set as 500, and 1000 users are trying to login at different time interval, so it wont allow users to login into the system? what error message will it give to them?

    rgds,
    Amit
    Reply With Quote Reply With Quote
  6. 10-10-2003, 04:30 PM #6
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    well Oracle will return unable to create process, depends how your application handles that isnt it
    Reply With Quote Reply With Quote
  7. 10-10-2003, 04:40 PM #7
    sysdba
    sysdba is offline Senior Member
    Join Date
    Jun 2000
    Posts
    295
    The default values of the SESSIONS and TRANSACTIONS parameters are derived from processes. So you do not need to set sessions.
    Reply With Quote Reply With Quote
  8. 10-10-2003, 07:38 PM #8
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    not necessarily true with sessions. I have had situations where i have blown the sessions parameter but not the processes one
    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