OraFAQ Forum: Performance Tuning » is there any limit for number of connections on a listner port

Home » RDBMS Server » Performance Tuning » is there any limit for number of connections on a listner port

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

is there any limit for number of connections on a listner port [message #223124]

Wed, 07 March 2007 12:25

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

BlackSwan
Messages: 26766
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.

Report message to a moderator

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

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

Report message to a moderator

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

BlackSwan
Messages: 26766
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.

Report message to a moderator

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

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

Report message to a moderator

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

BlackSwan
Messages: 26766
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.

Report message to a moderator

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

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

Report message to a moderator

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

BlackSwan
Messages: 26766
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?

Report message to a moderator

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

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

Report message to a moderator

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

BlackSwan
Messages: 26766
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)!

Report message to a moderator

Previous Topic:	performance of a query
Next Topic:	Does Concatenation in SQL query effect performance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 01:44:07 CST 2024