Message-Id: <10625.117484@fatcity.com> From: Satar Naghshineh Date: Wed, 20 Sep 2000 11:39:36 -0700 Subject: RE: Performance Increase over the Network 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@infy.com] > Sent: Wednesday, September 20, 2000 11:24 AM > To: 'Satar Naghshineh' > Cc: 'oracledba@quickdoc.co.uk'; 'ORACLE-L@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@irvine.mellesgriot.com] > > Sent: Tuesday, September 19, 2000 11:36 PM > > To: 'fuad@paktel.com'; oracledba@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@paktel.com [SMTP:fuad@paktel.com] > > Sent: Tuesday, September 19, 2000 9:08 AM > > To: oracledba@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@bitsmart.com < > > > > > ------_=_NextPart_001_01C02332.22BC9380 Content-Type: text/html Content-Transfer-Encoding: quoted-printable RE: Performance Increase over the Network

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     =