Solved

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

Posted on 2004-08-31
3
491 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
Comment Utility
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
Comment Utility
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
Comment Utility
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.

Join & Write a Comment

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
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.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

744 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now