Solved

How many processes can a Oracle 9i Release 2 Listener support?

Posted on 2004-08-31
3
497 Views
Last Modified: 2013-12-11
How many processes can a Oracle 9i Release 2 Listener support?  I realized there are variables to this question such as server hardware configuration and such, I just need a reasonable guess.

Our environment has 20+ Java applications accessing our database and performing selects, inserts, and updates to server tables.  We currently have only one listener created for the instance.  I am concerned that there may be a performance issue.  If someone can provide some guidelines I would appreciate it.

Regards.
0
Comment
Question by:john1953
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 7

Assisted Solution

by:BobMc
BobMc earned 80 total points
ID: 11948080
The listener is only used for the initial connection, it then starts up a user process, and hands off the client connection to it. Your apps can do as much DML as they want - it wont bother your listener!

Any limitation would only be in the number of concurrent connections (listener requests). I believe these will queue up if the listener is struggling to service them all. In any case, you can pre-spawn listener connections (takes longer at startup), so I would imagine the limit will never be reached in practise.

I always use one listener per instance, or even one per database server for smaller systems
HTH
Bob

0
 
LVL 4

Assisted Solution

by:andertst
andertst earned 80 total points
ID: 11949331
The only time I have not used a single listener per DB server is when a bug forces my hand.  There were a few bug with 8i and certain OS's (Tru64 I know of) but I think with the latest 8i releases they were fixed.  Have not run into any problem with 9i or 10g listeners, although 10g has been limited to play-time and research at home.  The 9i listeners have supported 20+ instances with a single listener with no problem.

You will only have problems if there are more concurrent connections than listener can handle.  I agree with Bob that it is unlikely to reach that for many systems, but the web changes everything so if you are deploying web-based apps, make sure you build test scenarios for hundreds or thousands of concurrent logins at the same time.

Stephen
0
 
LVL 48

Accepted Solution

by:
schwertner earned 90 total points
ID: 11950968
Oracle says that every process needs about 5MB RAM. Practically I estimate it about 2MB per process.
This is the only reasonable limitation of the number of the processes.

You will noit have problems with the Listener itself.
The real problem are the dead sessions that are often produced by Java and other
front-end applications. This means processes connected to canceled applications.
Oracle keeps these processes open and the result is very bad.

To avoid this you can force the listener to close dead sessions in a
period of time. To do this in SQLNET.ORA set
SQLNET.EXPIRE_TIME=30

This will cause every 30 minutes investigaten of the sessions and
deletion of all dead sessions.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question