Very slow initial connection on Oracle 8i

From: Harry <a_at_abc.com>
Date: Thu, 05 Dec 2002 11:56:16 GMT
Message-ID: <a6fuuu4jk1sjj4h3jma32edjcejuk4670s@4ax.com>

Using Oracle 8i enterprise on win 2000 (sp3)

Installed the standard configuration & whenever I make a connection it takes about 10 secs. It's running on a P1900 with 1gb Ram so no reason there for slowness.

Once I'm connected the queries work pretty much instantanously but to connect using SQLPLUS, Toad, ODBC, OLEDB all take about 10 secs. I connect using OLEDB from Visual Basic development environment & after the 1st connection (still in the dev env), subsequent connections are instant.

Where/what/how should I start - I'm totally baffled! - read somewhere that these symtoms could be DNS related but what/how do I tell & how to fix them?

I've included my TNSNAME.ORA & LISTENER.ORA files in the vain hope it might be something simple in these - the name of my database (only use the one) is dev

My TNSNAME.ORA file

# TNSNAMES.ORA Network Configuration File: i:\oracle\ora81\network\admin\tnsnames.ora # Generated by Oracle configuration tools.

DEV =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = p1900)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = dev)

    )
  )

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = p1900)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = dev)
(PRESENTATION = http://admin)

    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)

    )
  )

My LISTENER.ORA file

# LISTENER.ORA Network Configuration File: i:\oracle\ora81\network\admin\listener.ora # Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = p1900)(PORT = 1521))
      )

)
(DESCRIPTION =
(PROTOCOL_STACK =

        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )


      (ADDRESS = (PROTOCOL = TCP)(HOST = p1900)(PORT = 2481))

)
)

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = i:\oracle\ora81)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = dev)
(ORACLE_HOME = i:\oracle\ora81)
(SID_NAME = dev)

    )
  )

Many thanks

harry Received on Thu Dec 05 2002 - 05:56:16 CST