RE: Slow connection to Oracle 9i

From: Lincoln A Baxter (lincoln.a.baxter_at_bankofamerica.com)
Date: 10/18/04 

Date: Mon, 18 Oct 2004 13:16:43 -0400
To: dbi-users@perl.org

Most people with experience with Oracle know that opening oracle connections
is SLOW!

Oracle does not appear to consider that a problem, just like they do not
consider slow performance for doing DDL a problem

Applications that require near real time (OLTP) response times open
connections once, and hold open oracle connections across transactions.
This is true regardless of the language on the client side. That is why,
for instance, Websphere caches pooled connections in the java world.

Lincoln

-----Original Message-----
From: Tim Bunce [mailto:Tim.Bunce@pobox.com]
Sent: Monday, October 18, 2004 12:06 PM
To: Paul Appleby
Cc: dbi-users@perl.org
Subject: Re: Slow connection to Oracle 9i

On Mon, Oct 18, 2004 at 10:38:23AM -0400, Paul Appleby wrote:
>
> >DBD::Oracle::dr::load_dbnames is only called by data_sources()
> >so don't call data_sources() unless you really need to.
>
> I really do need to call data_sources() but the time it takes to
> retrieve data, as shown above, using "Time::HiRes" is only
> 0.0100140571594238 seconds. So that's not the issue.

dprofpp showed it to take approx the same time as login:

> %Time ExclSec CumulS #Calls sec/call Csec/c Name
> 21.6 0.090 0.090 1 0.0900 0.0900 DBD::Oracle::db::_login
> 21.6 0.090 0.159 1 0.0899 0.1592 DBD::Oracle::dr::load_dbnames
> 21.6 0.090 0.159 6 0.0149 0.0265 main::BEGIN

Anyway, I think there's little you can do from DBI to make Oracle
connections faster than you already have. Look to changes on the
Oracle side - for which other mailing lists (such as oracle-l) are
more suitable.

Tim.

Relevant Pages

  • Re: Effect of listener on existing connections?
    ... Oracle support is not giving us satisfactory results. ... and attempts to create new connections are ... We also see these messages appearing with regularity in our listener ... how does a blocked listener explain the fact that apps with existing ...
    (comp.databases.oracle.server)
  • Re: Effect of listener on existing connections?
    ... Solaris 10 inside a ZFS zone (our previous system was Oracle ... and attempts to create new connections are ... issue of the listener locking up if you're not using ONS. ... how does a blocked listener explain the fact that apps with existing ...
    (comp.databases.oracle.server)
  • Connection delays causing problems.
    ... ORACLE connections sometimes take tens of seconds to come ... This is true whether the connection is via sqlplus, ACCELL ... Over 150 clients running ACCELL applications. ...
    (comp.databases.oracle.server)
  • Effect of listener on existing connections?
    ... Oracle support is not giving us satisfactory results. ... and attempts to create new connections are ... how does a blocked listener explain the fact that apps with existing ...
    (comp.databases.oracle.server)
  • Re: Can Access handle this configuration, or do I need SQL Server?
    ... My company runs a couple of mdbs and one large scale Oracle back ... end db system over both Citrix and RDP client connections. ... functioning correctly) and problems caused by flaky connections. ...
    (microsoft.public.access.formscoding)