Message-Id: <10581.113923@fatcity.com> From: "Andrey Bronfin" Date: Sun, 6 Aug 2000 17:56:00 +0200 Subject: Re: Multiple listeners question This is a multi-part message in MIME format. ------=_NextPart_000_0013_01BFFFCF.947DF8A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear DBAs ! I'm reposting this just to clarify that i'm talking about multiple = listeners for THE SAME database in order to maximize performance ... Thanks a lot ! ----- Original Message -----=20 From: Andrey Bronfin=20 To: ORACLE-L@lists.sunysb.edu ; ORACLE-L@fatcity.com ; = oracledba@quickdoc.co.uk=20 Sent: Sunday, August 06, 2000 5:31 PM Subject: Multiple listeners question 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_0013_01BFFFCF.947DF8A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Dear DBAs !
I'm reposting this just to clarify that = i'm talking=20 about multiple listeners for THE SAME database in order to maximize = performance=20 ...
Thanks a lot !
----- Original Message -----
From:=20 Andrey=20 Bronfin
To: ORACLE-L@lists.sunysb.edu ; ORACLE-L@fatcity.com ; oracledba@quickdoc.co.uk
Sent: Sunday, August 06, 2000 = 5:31=20 PM
Subject: Multiple listeners=20 question

 
Dear all !
 
I'm going to administer an Oracle = 8.1.6 DB on Sun=20 220 machine .
Most of the SQL statements against = the DB will=20 retrieve a values from a BLOB or a CLOB column .
Typical LOB size is ~25 - 50K = .
We expect ~ 700 such queries per = second=20 .
 
The question : someone suggested me = to configure=20 more than one listener on the DB server in order to balance the load=20 .
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 ?
How can i implement multiple = listeners=20 ?
Are there any papers on this =
 
TIA

Andrey=20 Bronfin
VisualTop.com