How many connections are ok per CPU on Oracle9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How many connections are ok per CPU on Oracle9i

Hybrid View

  1. #1
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448

    How many connections are ok per CPU on Oracle9i

    Oracle 9i EE
    Hi, does somebody knows,
    how many dedicated-server sessions the Oracle-Server can handle per CPU?

    * 100 ?
    * 200 ?
    * 300 ?
    * 400 ?
    * 500 ?

    Thanks in advice
    Orca

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    One single session, being absolutely the only user process connected to your computer, can load your CPU up to 100% for a long time very easily.

    On the other hand you could have thousands of users connected on that same CPU (provided you have *a lot* of physical memory available) and the CPU will be idle for most of the time, if those sessions are only connected and don't do anything.

    It's not the number of sessions that load the CPU, it is what those sessions are doing...
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Originally posted by jmodic
    One single session, being absolutely the only user process connected to your computer, can load your CPU up to 100% for a long time very easily.

    On the other hand you could have thousands of users connected on that same CPU (provided you have *a lot* of physical memory available) and the CPU will be idle for most of the time, if those sessions are only connected and don't do anything.

    It's not the number of sessions that load the CPU, it is what those sessions are doing...
    ok, then if it's a new application, the only way is to test it.
    Thanks
    Orca

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