Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Multiple listeners question
This is a multi-part message in MIME format.
------=_NextPart_000_037E_01C00131.B7A4CCB0 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi All !
I forgot to say : that someone told me that if we're going to transfer =
25-50 K of LOBs every query then the network will be very busy .
So we'll need 2 network cards with 2 different IP addresses for the same =
physical machine in order to improve network throughput .
This is where the 2 listeners for 2 IPs of the same machine are =
introduced=20
Did this someone explain why multiple listeners would benefit you? The = listener is only involved during the initial connection to the database = and has nothing to do with query performance. If you have a lot of new = connections hitting the server simultaneously, then by all means try = balancing the load with multiple listeners and see if you gain anything. = Or if you want to debug the listener, set up a separate listener on a = separate port for debuggig purposes. But I don't see how it'll improve = query performance.
Andrey Bronfin <bronfin_at_VisualTop.com> wrote:=20
Dear all !
I'm going to administer an Oracle 8.1.6 DB on Sun 220 machine .
Most of the SQL statements against the DB will retrieve a values = from a BLOB or a CLOB column .
Typical LOB size is ~25 - 50K ..
We expect ~ 700 such queries per second ..
The question : someone suggested me to configure more than one = listener on the DB server in order to balance the load ..
Do U think it's appropriate ? Does anyone have any experience with = multiple listeners on the same machine and for the SAME INSTANCE ?
How can i implement multiple listeners ?
Are there any papers on this=20
TIA=20
Andrey Bronfin
VisualTop.com
=20
-------------------------------------------------------------------------=
------=_NextPart_000_037E_01C00131.B7A4CCB0 Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content=3D"text/html; charset=3Diso-8859-1" =http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR></HEAD> <BODY bgColor=3D#d4d0c8> <DIV><FONT face=3DArial size=3D2>Hi All !</FONT></DIV> <DIV><FONT face=3DArial size=3D2>I forgot to say : that =someone told me=20
question</DIV>
<DIV><BR></DIV>
<P>Did this someone explain why multiple listeners would benefit you?=20
The listener is only involved during the initial connection =
to the=20
database and has nothing to do with query performance. If =
you have a=20
lot of new connections hitting the server simultaneously, then by =
all=20
means try balancing the load with multiple listeners and see if =
you gain=20
anything. Or if you want to debug the listener, set up a separate =
listener on a separate port for debuggig purposes. But I don't =
see=20
how it'll improve query performance.</P>
<P> <B><I>Andrey Bronfin <bronfin_at_VisualTop.com></I></B> =
wrote:=20
<BR></P>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; =
PADDING-LEFT: 5px"><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 =
Transitional//EN"><BR>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR><BR> <STYLE></STYLE> <BR><BR> <DIV> </DIV><BR> <DIV><FONT face=3DArial size=3D2>Dear all !</FONT></DIV><BR> <DIV> </DIV><BR> <DIV><FONT face=3DArial size=3D2>I'm going to administer an Oracle =8.1.6 DB on=20
Sun 220 machine .</FONT></DIV><BR>
<DIV><FONT face=3DArial size=3D2>Most of the SQL statements against =
the DB will=20
retrieve a values from a BLOB or a CLOB column .</FONT></DIV><BR>
<DIV><FONT face=3DArial size=3D2>Typical LOB size is ~25 - 50K=20
..</FONT></DIV><BR>
<DIV><FONT face=3DArial size=3D2>We expect ~ 700 such queries per =
second=20
..</FONT></DIV><BR>
<DIV> </DIV><BR>
<DIV><FONT face=3DArial size=3D2>The question : someone suggested me =
to=20
configure more than one listener on the DB server in order to = balance the=20
load ..</FONT></DIV><BR>
<DIV><FONT face=3DArial size=3D2>Do U think it's appropriate ? Does =
anyone have=20
any experience with multiple listeners on the same machine and for=20 the SAME INSTANCE ?</FONT></DIV><BR> <DIV><FONT face=3DArial size=3D2>How can i implement multiple = listeners=20
?</FONT></DIV><BR>
<DIV><FONT face=3DArial size=3D2>Are there any papers on this =
</FONT></DIV><BR>
<DIV> </DIV><BR> <DIV><FONT face=3DArial size=3D2>TIA </FONT></DIV><BR> <DIV><FONT face=3DArial size=3D2><BR>Andrey=20Bronfin<BR>VisualTop.com<BR></DIV></FONT><BR>
<DIV> </DIV><BR> <DIV><FONT face=3DArial = size=3D2><BR></FONT> </DIV></BLOCKQUOTE>