RE: Multiple listeners question

From: Singla, Sanjeev K. <SSingla_at_oxhp.com>
Date: Mon, 7 Aug 2000 11:43:47 -0400
Message-Id: <10582.113976@fatcity.com>

Multiple listerners on the same machine for same instance in dedicated mode are only
needed to balance the load of too many simultaneous connections. for eg. if all 700 people
are logging atonce. Once you are connected listener is out of sight.So it will not help u if
they are already logged in successfully and then running queries. But if you have problems
while 700 simultaneous people log in then u will be definitely benefited.

Sanjeev

-----Original Message-----
From: Suzy Vordos [mailto:lvordos_at_uswest.com] Sent: Monday, August 07, 2000 11:15 AM
To: Multiple recipients of list ORACLE-L Subject: Re: Multiple listeners question

Yes, this can be done, here is an example...

####
# LSNR01
####

LSNR01 =
  (ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY=LSNR01))
(ADDRESS= (PROTOCOL= TCP)(Host=host.domain)(Port= 1521))
  )
SID_LIST_LSNR01 =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = oradb01)
(ORACLE_HOME=/dbms/ora00/app/oracle/product/8.0.6)
(ENVS='EPC_DISABLED=TRUE')

    )
    (SID_DESC =
(SID_NAME = oradb02)
(ORACLE_HOME=/dbms/ora00/app/oracle/product/8.0.6)
(ENVS='EPC_DISABLED=TRUE')

    )
  )
STARTUP_WAIT_TIME_LSNR01 = 0
CONNECT_TIMEOUT_LSNR01 = 10
TRACE_LEVEL_LSNR01 = OFF

####
# LSNR02
####

LSNR02 =
  (ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY=LSNR02))
(ADDRESS= (PROTOCOL= TCP)(Host=host.domain)(Port= 1526))
  )
SID_LIST_LSNR02 =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = oradb01)
(ORACLE_HOME=/dbms/ora00/app/oracle/product/8.0.6)
(ENVS='EPC_DISABLED=TRUE')

    )
    (SID_DESC =
(SID_NAME = oradb02)
(ORACLE_HOME=/dbms/ora00/app/oracle/product/8.0.6)
(ENVS='EPC_DISABLED=TRUE')

    )
  )
STARTUP_WAIT_TIME_LSNR02 = 0
CONNECT_TIMEOUT_LSNR02 = 10
TRACE_LEVEL_LSNR02 = OFF

> Andrey Bronfin 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
> 
> 
>

-- 
Author: Suzy Vordos
  INET: lvordos_at_uswest.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may

Received on Mon Aug 07 2000 - 10:43:47 CDT