Re: Multiple listeners question

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Mon, 7 Aug 2000 06:32:32 -0700 (PDT)
Message-Id: <10582.113966@fatcity.com>

--0-1189641421-965655152=:5672
Content-Type: text/plain; charset=us-ascii

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:

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

TIA Andrey Bronfin
VisualTop.com

Do You Yahoo!?
Kick off your party with Yahoo! Invites. --0-1189641421-965655152=:5672
Content-Type: text/html; charset=us-ascii

<P>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.</P>
<P>  <B><I>Andrey Bronfin <bronfin_at_VisualTop.com></I></B> wrote: <BR></P>
<BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px"><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><BR>
<META content="MSHTML 5.00.2920.0" name=GENERATOR><BR>
<STYLE></STYLE>
<BR><BR>
<DIV> </DIV><BR>
<DIV><FONT face=Arial size=2>Dear all !</FONT></DIV><BR>
<DIV> </DIV><BR>
<DIV><FONT face=Arial size=2>I'm going to administer an Oracle 8.1.6 DB on Sun 220 machine .</FONT></DIV><BR>
<DIV><FONT face=Arial size=2>Most of the SQL statements against the DB will retrieve a values from a BLOB or a CLOB column .</FONT></DIV><BR>
<DIV><FONT face=Arial size=2>Typical LOB size is ~25 - 50K ..</FONT></DIV><BR>
<DIV><FONT face=Arial size=2>We expect ~ 700 such queries per second ..</FONT></DIV><BR>
<DIV> </DIV><BR>
<DIV><FONT face=Arial size=2>The question : someone suggested me to configure more than one listener on the DB server in order to balance the load ..</FONT></DIV><BR>
<DIV><FONT face=Arial size=2>Do U think it's appropriate ? Does anyone have any experience with multiple listeners on the same machine and for the SAME INSTANCE ?</FONT></DIV><BR>
<DIV><FONT face=Arial size=2>How can i implement multiple listeners ?</FONT></DIV><BR>
<DIV><FONT face=Arial size=2>Are there any papers on this </FONT></DIV><BR>
<DIV> </DIV><BR>
<DIV><FONT face=Arial size=2>TIA </FONT></DIV><BR>
<DIV><FONT face=Arial size=2><BR>Andrey Bronfin<BR>VisualTop.com<BR></DIV></FONT><BR>
<DIV> </DIV><BR>
<DIV><FONT face=Arial size=2><BR></FONT> </DIV></BLOCKQUOTE><p><br><hr size=1><b>Do You Yahoo!?</b><br>
Kick off your party with Yahoo! Invites. Received on Mon Aug 07 2000 - 08:32:32 CDT