RE: Performance Increase over the Network

From: Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
Date: Wed, 20 Sep 2000 11:39:36 -0700
Message-Id: <10625.117484@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C02332.22BC9380
Content-Type: text/plain

If you feel that your listener cannot handle the connections, then you can add another listener. If the listener cannot handle the request, your clients will get an ORA error.

As to Thumb rules, I have none. If it ain't broken (no error), don't fix it?

when speaking to Oracle support, they told me not to set QUESIZE too high and that I should set it to 50. I don't know what their definition of "too high" is. What is the default? I don't know that either.

Here's my listener.ora file:

LISTENER =
  (ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY= FRED))
        (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY)) (ADDRESS= (PROTOCOL= TCP)(Host= proddb)(Port= 1521)(QUEUESIZE=50))   )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME= proddb.)
(ORACLE_HOME= /u01/app/oracle/product/7.3.4)
(SID_NAME = FRED)

    )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF

> -----Original Message-----
> From:	VIVEK_SHARMA [SMTP:VIVEK_SHARMA_at_infy.com]
> Sent:	Wednesday, September 20, 2000 11:24 AM
> To:	'Satar Naghshineh'
> Cc:	'oracledba_at_quickdoc.co.uk'; 'ORACLE-L_at_fatcity.com'
> Subject:	RE: Performance Increase over the Network
> 
> 
> When Exceeding what Number Oracle Connections to go in for a 2nd listener
> ?
> (Any Thumb-rules ?)
> QUEUESIZE can be increase to what  value  ? (Any recommended values ?)
> What is the Default value of Queuesize though ?
> 
> 
> 
> > -----Original Message-----
> > From:	Satar Naghshineh
> [SMTP:Satar.Naghshineh_at_irvine.mellesgriot.com]
> > Sent:	Tuesday, September 19, 2000 11:36 PM
> > To:	'fuad_at_paktel.com'; oracledba_at_lazydba.com
> > Subject:	RE: Performance Increase over the Network
> > 
> > Two ways of accepting more connections via the listener port: 
> > create a second listener on a different port and off set your
> connections
> > or just 
> > Increase the QUEUESIZE parameter in your listener.ora file. If your
> > network is faster than Oracle's ability to accept listener connections,
> > then I want your Network admin to work for me!
> > 
> > Regards,
> > Satar 
> > 
> > 	-----Original Message----- 
> > From:   fuad_at_paktel.com [SMTP:fuad_at_paktel.com] 
> > Sent:   Tuesday, September 19, 2000 9:08 AM 
> > To:     oracledba_at_lazydba.com 
> > Subject:        Performance Increase over the Network 
> > 
> > 	Can Multiple listeners help in Increasing Perfomance over the
> > Network. I've got Application running at multiple location with
> > connectivity to  my Main Server.
> > 
> > 	I need to optimize network Bandwidth Usage and Performance across
> > the networks 
> > Regards 
> > Fuad Arshad 
> > Systems Administration Group 
> > Paktel Limited 
> > Ph:92-303-7270100 
> > Email :fuad_at_bitsmart.com < <mailto::fuad_at_bitsmart.com>> 
> >   
> >

------_=_NextPart_001_01C02332.22BC9380
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>RE: Performance Increase over the Network</TITLE>
</HEAD>
<BODY>

If you feel that = your listener cannot handle the connections, then you can add another = listener. If the listener cannot handle the request, your clients will = get an ORA error.

As to Thumb rules, I = have none. If it ain't broken (no error), don't fix it?

when speaking to = Oracle support, they told me not to set QUESIZE too high and that I = should set it to 50. I don't know what their definition of "too = high" is. What is the default? I don't know that = either.

Here's my = listener.ora file:

LISTENER =3D   = (ADDRESS_LIST =3D
  (ADDRESS=3D = (PROTOCOL=3D IPC)(KEY=3D FRED))
         (ADDRESS=3D = (PROTOCOL=3D IPC)(KEY=3D PNPKEY))  (ADDRESS=3D = (PROTOCOL=3D TCP)(Host=3D proddb)(Port=3D 1521)(QUEUESIZE=3D50))   ) SID_LIST_LISTENER = =3D
   (SID_LIST = =3D
     = (SID_DESC =3D
       (GLOBAL_DBNAME=3D = proddb.)
       (ORACLE_HOME=3D = /u01/app/oracle/product/7.3.4)
       (SID_NAME =3D = FRED)
     = )
   ) STARTUP_WAIT_TIME_LISTENER =3D 0 CONNECT_TIMEOUT_LISTENER =3D 10 TRACE_LEVEL_LISTENER =3D OFF     =

</FONT>
</P>
<UL>
<P><FONT SIZE=3D1 FACE=3D"Arial">-----Original Message-----</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">From:&nbsp;&nbsp;</FONT></B> <FONT =

SIZE=3D1 FACE=3D"Arial">VIVEK_SHARMA =
[SMTP:VIVEK_SHARMA_at_infy.com]
 Sent:   Wednesday, September 20, 2000 11:24 AM To:     'Satar Naghshineh' Cc:     'oracledba_at_quickdoc.co.uk'; = 'ORACLE-L_at_fatcity.com'
 Subject:       = RE: Performance Increase over the = Network

When Exceeding what Number Oracle = Connections to go in for a 2nd listener ? (Any Thumb-rules ?) QUEUESIZE can be increase to = what  value  ? (Any recommended values ?) What is the Default value of = Queuesize though ?

</P>
<BR>
<BR>

> -----Original Message----- > From: Satar Naghshineh = [SMTP:Satar.Naghshineh_at_irvine.mellesgriot.com] > Sent: Tuesday, September 19, = 2000 11:36 PM
 > To:   = 'fuad_at_paktel.com'; oracledba_at_lazydba.com > = Subject:      RE: Performance Increase over = the Network
 > > Two ways of accepting more = connections via the listener port: > create a second listener on a = different port and off set your connections > or just > Increase the QUEUESIZE parameter = in your listener.ora file. If your > network is faster than Oracle's = ability to accept listener connections, > then I want your Network admin = to work for me!

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Regards,</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Satar </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

-----Original Message----- 
 > From:   = fuad_at_paktel.com [SMTP:fuad_at_paktel.com]

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Sent:&nbsp;&nbsp; Tuesday, =
September 19, 2000 9:08 AM </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; To:&nbsp;&nbsp;&nbsp;&nbsp; =

oracledba_at_lazydba.com 
 > = Subject:        Performance Increase = over the Network 
 > >       = Can Multiple listeners help in Increasing Perfomance over the > Network. I've got Application = running at multiple location with > connectivity to  my Main = Server.
 > >       I = need to optimize network Bandwidth Usage and Performance across

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; the networks </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Regards </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Fuad Arshad </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Systems Administration Group =
</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Paktel Limited </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Ph:92-303-7270100 </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Email :fuad_at_bitsmart.com &lt; =

<<A = HREF=3D"mailto::fuad_at_bitsmart.com">mailto::fuad_at_bitsmart.com</A>></FO= Received on Wed Sep 20 2000 - 13:39:36 CDT