Home » RDBMS Server » Performance Tuning » is there any limit for number of connections on a listner port
is there any limit for number of connections on a listner port [message #223124] Wed, 07 March 2007 12:25 Go to next message
najehas
Messages: 10
Registered: March 2007
Junior Member
hi dear all
i want to ask if ther is any limit or how many maximum connections could be handled by a listner using one port only

[Updated on: Wed, 07 March 2007 12:29]

Report message to a moderator

Re: is there any limit for number of connections on a listner port [message #223125 is a reply to message #223124] Wed, 07 March 2007 12:29 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
> i want to ask if ther is any limit or how many maximum connections could be handled by a listner using one port only
No, no limit.
The listener ONLY is involved for establishing the initial connection between a new client connection & the database.
After the client is talking to the DB directly, the listener never has anything to do for that client session.
Re: is there any limit for number of connections on a listner port [message #223126 is a reply to message #223125] Wed, 07 March 2007 12:32 Go to previous messageGo to next message
najehas
Messages: 10
Registered: March 2007
Junior Member
thanks for asking and i want to know what if there is way to ensure that my oracle 10g db could handle more than 2000 concurent connections in a good response time
Re: is there any limit for number of connections on a listner port [message #223128 is a reply to message #223124] Wed, 07 March 2007 12:40 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
> i want to know what if there is way to ensure that my oracle 10g db could handle more than 2000 concurent connections in a good response time
Money can solve this problem; a 16 CPU system with 32+GB RAM & 100 iSCSI disks in RAID1+0 array.
Re: is there any limit for number of connections on a listner port [message #223129 is a reply to message #223128] Wed, 07 March 2007 12:45 Go to previous messageGo to next message
najehas
Messages: 10
Registered: March 2007
Junior Member
thanks alot but do you think 4 cpu 64-bit with 8g.b and emc mass storgae could be enough to for that
Re: is there any limit for number of connections on a listner port [message #223133 is a reply to message #223124] Wed, 07 March 2007 12:55 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
It depends upon the application & how well (or poorly) it is designed & written.

My gut feeling is that the proposed hardware will produce SLOW OLTP response times.

I had a system configured similar to above & supported 1800+ concurrent users, but it needed all available resources.

The ONLY way to know for sure is to go live & see what happens.
Re: is there any limit for number of connections on a listner port [message #223134 is a reply to message #223133] Wed, 07 March 2007 13:00 Go to previous messageGo to next message
najehas
Messages: 10
Registered: March 2007
Junior Member
thank you and please did you find or know any tool that could examin that and you recomend it, to test the server
Re: is there any limit for number of connections on a listner port [message #223137 is a reply to message #223124] Wed, 07 March 2007 13:05 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
One of the more well known utilities is Mercury LoadRunner, but such tool is only as good as the folks setting it up. (GIGO)
What is the application?
In what language(s) is the application written?
What is the interface between the end users & the DB?
Re: is there any limit for number of connections on a listner port [message #223138 is a reply to message #223137] Wed, 07 March 2007 13:14 Go to previous messageGo to next message
najehas
Messages: 10
Registered: March 2007
Junior Member
ok thank you, the application is written in java servelts using tomcat about 4 web servers are access this database each server could handle up to 512 users concurently;
and the application is a regestration web application for the university students in normal days all users work smoothly on the web but there is apeek time just for 2 or three days in the start of the semester at that time acrash happend on the DB more times (i.e the db servere must be restarted to overcome this problem )
thank you in advance for your help and sugesstions
Re: is there any limit for number of connections on a listner port [message #223140 is a reply to message #223124] Wed, 07 March 2007 13:23 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>thank you in advance for your help and sugesstions
If the application is NOT using BIND variables, then it should be renamed SS Titanic.
I have yet to see a truly scalable application written in Java & using Oracle as the "data persistence layer".
You're On Your Own (YOYO)!
Previous Topic: performance of a query
Next Topic: Does Concatenation in SQL query effect performance
Goto Forum:
  


Current Time: Thu Dec 08 10:22:45 CST 2016

Total time taken to generate the page: 0.05249 seconds