Re: How To Improve Connection Times?

From: Khalid Eidoo <someone_at_rogers.com>
Date: Sun, 26 May 2002 14:53:24 GMT
Message-ID: <EF6I8.96257$ah_.59263@news01.bloor.is.net.cable.rogers.com>

The machines all sit together on a segmented 100Mb switch. Consequently, pings are very low, usually 1-3Milliseconds. There is no firewall involved, the only other service we have running (SSH) connects almost instantly. I don't believe it is a network issue as it is something in the configuration of our listeners. I have included our listener information below.

# LISTENER.ORA Network Configuration File: /home/oracle/config/9.0.1/listener.ora
# Generated by Oracle configuration tools.

FORSYS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = forsys.terida.com)(PORT = 1521)) )

SAVE_CONFIG_ON_STOP_FORSYS = TRUE SID_LIST_FORSYS =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME = forsys.terida.com)
(ORACLE_HOME = /opt/oracle/product/9.0.1)
(SID_NAME = forsys)

    )
  )

# TNSNAMES.ORA Network Configuration File: /home/oracle/config/9.0.1/tnsnames.ora
# Generated by Oracle configuration tools.

FORSYS =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = forsys)

    )
  )

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:uevh0cg99g4650_at_corp.supernews.com...

>
> "Khalid Eidoo" <someone_at_rogers.com> wrote in message
> news:M8PH8.111123$t8_.88933_at_news01.bloor.is.net.cable.rogers.com...
> > Hello,
> >
> > We have an Oracle9i installation running on Linux. The specs of the
> machine
> > are below. Basically, we are developing a simple client/server

application

> > using the OLEDB provider for Oracle. The only real problem we are
> > experiencing is creating an initial connection. The first connection we
> > create generally takes 5-7 seconds to establish. Once connected, the SQL
> > commands executed are extremely quick.
> >
> > While I do know that creating connections is generally an expensive
> command,
> > i've never seen seen a connection take so long to establish. This server
> is
> > under no load whatsoever (development machine). Also, when I was playing
> > with Informix IDS 9.2, connection time was generally under 2 seconds.
> >
> > Does anyone have any suggestions on improving connection speeds (we are
> > pooling connections etc., its just that the first connection is

extremely

> > slow).
> >
> > Our configuration is:
> >
> > RedHat 7.2
> > Pentium III 1.26GHz
> > 1.2GB RAM
> > 20GB IDE HDD (the actual database is less than 5MB and I/O for us isn't

> > issue).
> > 10/100 NIC
> > Oracle9.0.1
> >
> > Please post responses to the newsgroup. Thank-you,
> >
> > Khalid.
> >
> >
>
> This must be a network and/or a sqlnet configuration issue.
> You don't provide any details on that.
> We need to have
> listener.ora, tnsnames.ora and sqlnet.ora
> Also we need to know whether the client can ping the server in a

reasonable

> amount of time, what the traceroute results are between the systems, and
> whether a firewall is involved.
>
> Regards
>
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
>
>

Received on Sun May 26 2002 - 09:53:24 CDT