×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Connections/Processes

Connections/Processes

Connections/Processes

(OP)
My application is running out of processes. It seems like it will need about 200. Is that a lot? Whats the max number Oracle can handle and how much memory does oracle need per connection. Whats a good rule of thumb for calculation of connections...

I can find any good information on this issue, so any help greatly appreciated!!

Cal


RE: Connections/Processes

Hi Cal,

Memory usage:

I don't have the Oracle documentation to hand so this is from my (probably unreliable) memory.

Allow about 1mb per user (per connection that is.

Add the total size of the SGA (from the init.ora file for that DB)

Add the size of the oracle daemons (use the ps command to find that out)

This is pretty well documented in the "Planning your database" section of the Oracle manuals actually.

Processes:

This is limited by the operating system rather than Oracle. What operating system are you running the database server under?

Mike
michael.j.lacey@ntlworld.com
Cargill's Corporate Web Site

RE: Connections/Processes

   The max number of processes is set in your init.ora file.  However,
the semaphores parameter in the kernel also needs to be set high
enough to support Oracle and other processes, assuming that you
are on unix.

Jim Carlson
nx56@inetarena.com

oracle, vb, some javascript

RE: Connections/Processes

(OP)
Thanks guys.

I'm running the database on HP-UX.

I'm trying to get a handle on this whole connection/process. In SQL Server you open a connection to a database - fair enough, and SS can handle around 65000 of these. With Oracle, as listener22 pointed out, a process can have thousands of threads. So having a hunderd processes can give you hunders of thousands of "pipes" to send  query down (which is a equivalent to a SQL server "connection".

How can I get the kernel parameters - what is the UNIX command?

How come when I connect via JDBC to the database, I'm getting a new Process rather than using an existing process and getting one of its "threads"?

Is this correct, or does it read like the last journal entry from a doomed artic explorer?

Thanks in advance

Cal


RE: Connections/Processes

   I'm not sure that I said that a process can have thousands of
threads, but in any case you want to make sure that you have
a backup of your kernel before you make any changes.  If you
have access to meta-link, search on 'semaphores' to get some
idea of the recommended values for kernel parameters.  Or,
see the Oracle installation guide.

Jim Carlson
nx56@inetarena.com

oracle, vb, some javascript

RE: Connections/Processes

Cal,

In addition to the init.ora parameter re number of processes (which I didn't know about by the way, thx Jim) there are kernel parameters that limit the number of processes on HPUX. These may need to be modified as well

I'm not an SS guy but it sounds as if SS uses quite different terminology to Oracle. In Oracle you do have the multi-threaded server, but you talk about processes and not threads.

Each connection to a db implies two extra processes:

1 - A client process; this may or may not be on the database server.

2 - A server process to talk between 1 and the database daemons.

Mike
michael.j.lacey@ntlworld.com
Cargill's Corporate Web Site

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close