Solved

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

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

911 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

16 Experts available now in Live!

Get 1:1 Help Now