Re: Slow connection to Oracle 9i

From: Peter J. Holzer (hjp_at_wsr.ac.at)
Date: 10/19/04 

Date: Tue, 19 Oct 2004 10:43:25 +0200
To: dbi-users@perl.org

On 2004-10-18 11:48:11 -0600, Reidy, Ron wrote:
> Maybe Oracle does not think it is a problem, but I (and lots of
> others) would disagree. These issues are correctable.
>
> In the case of slow logins, it depends on what is being done when the
> connection is made. When making connections that are dedicated server
> (not MTS) a process is created. If your server is memory and/or CPU
> bound, this could take a long time.

On a lightly loaded server, OTOH, it doesn't seem to make much
difference: I just tested it on two oracle instances on identical
hardware. Connecting to one with MTS took 0.059 seconds, connecting to
the one without took 0.064 seconds (of course there are other
differences between those databases as well, so this may not indicate
anything).

Invoking the script for the first time takes a lot longer (about 0.5
seconds), so I guess loading DBD::Oracle and the oracle shared libraries
from disk just takes some time.

> Other causes could be the any after-logon triggers that may be firing.

Other delays could be in finding the database and authenticating the
user. We only use tnsnames.ora and plain database users here, which is
probably the fastest method. If the client has to ask the oracle name
server where the database is, and the database has to ask an LDAP server
to authenticate the user, this will cause additional delays, which may
be noticable.

        hp 

-- 
   _  | Peter J. Holzer      | Shooting the users in the foot is bad. 
|_|_) | Sysadmin WSR / LUGA  | Giving them a gun isn't.
| |   | hjp@wsr.ac.at        |	-- Gordon Schumacher,
__/   | http://www.hjp.at/   |     mozilla bug #84128

Relevant Pages

  • Re: "Correct" term for a 1:1 relationship between a "database" and an "instance" where > 1 such thin
    ... Nearly all the Oracle docs and books define a database something like ... unpartitioned physical server? ...
    (comp.databases.oracle.server)
  • Linked Server (Oracle 9i)
    ... Having problems connecting to an Oracle 9i database from within ... Microsoft ODBC for Oracle ... Windows 2000 - Advanced Server ... OLE DB error trace [OLE/DB Provider 'MSDAORA' ...
    (microsoft.public.sqlserver.odbc)
  • Linked Server (Oracle 9i)
    ... Having problems connecting to an Oracle 9i database from within ... Microsoft ODBC for Oracle ... Windows 2000 - Advanced Server ... OLE DB error trace [OLE/DB Provider 'MSDAORA' ...
    (microsoft.public.sqlserver)
  • RE: Problem with connecting to an Oracle database using Perl
    ... Problem with connecting to an Oracle database using Perl ... *IS* described in the DBD::Oracle perldocs - as the perldocs are included ... I do not have a problem connecting to the remote database using the Oracle ...
    (perl.dbi.users)
  • RE: Vulnerability analysis tools
    ... Definitely you want your Oracle database behind a firewall. ... tell you the database is not meant to be exposed to the internet directly. ... 1- A web server hosted at an IDC ...
    (Security-Basics)