RE: Speed test for connecting to Oracle for Windows via ODBC

-----Original Message-----
From: Ron Savage [mailto:ron@xxxxxxxxxxxxx]
Sent: Tuesday, June 13, 2006 6:11 PM
To: List - DBI users
Subject: RE: Speed test for connecting to Oracle for Windows via ODBC

On Tue, 13 Jun 2006 09:57:38 -0400, Garrett, Philip \(MAN-Corporate\)
wrote:

-> Test Connection

How long does that take to acknowledge success?

It's 16 seconds after clicking Test before the dialog box pops up
asking for the password. That may well be a Window-inspired delay
of course.

Then, after entering the pw and clicking OK, it's usually < 1 sec.

However on the first test after booting, after clicking OK it was
around 7 .. 8 seconds (sound familiar?)

This is all on a home PC with a broadband connexion to the internet,
and no other PCs in the house.

My first guess is that the server is attempting to do reverse lookup on
you. My (general, not Oracle) experience has been that when there's a
several second delay when connecting, but everything is fine thereafter,
it's usually reverse DNS.

I use DBD::ADO to get at Oracle over ODBC without any problems. But of
course changing to ADO won't help you, because you have a network/Oracle
setup problem.

How long does it take to connect via sqlplus? tnsping?

Philip
.

Relevant Pages

  • RE: Windows to Oracle
    ... resolved yet (with respect to a Windows OS). ... and Oracle DBDs. ... Need to install Oracle on your own machine before you can connect to the ... If you are truly trying to use ODBC, why are you specifying the Oracle ...
    (perl.dbi.users)
  • Re: MSACCESS hangs
    ... Client -- Windows XP, MS Access 2003 using Oracle's ODBC driver ... I would try to isolate whether it is the query or ODBC. ... Senior Oracle Dba ... other thoughts are windows patches may have been installed, ...
    (comp.databases.oracle.server)
  • Re: Accessing Oracle from Python
    ... You don't want to use ODBC as that is a Windows interface ... that doesn't natively exist on Linux. ... Access to remote Oracle databases is just done via TCP ...
    (comp.lang.python)
  • Re: MSACCESS hangs
    ... Client -- Windows XP, MS Access 2003 using Oracle's ODBC driver ... I would try to isolate whether it is the query or ODBC. ... Senior Oracle Dba ... other thoughts are windows patches may have been installed, ...
    (comp.databases.oracle.server)
  • Re: ODBC from Windows to Oracle 7 on UNIX
    ... I am very new with Oracle. ... This company has Oracle 7 on UNIX and I want to establish ODBC from ... I am having trouble to connecting the client to the Oracle ...
    (comp.databases.oracle.server)
Loading