Solved

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

Posted on 2004-08-31
3
494 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
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 47

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

770 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