RE: Slow connection to Oracle 9i

From: Jared Still (jkstill_at_cybcon.com)
Date: 10/24/04

  • Next message: Ron Savage: "Re: binding multiple values and retain blanks" 
    To: "BAXTER, LINCOLN A" <lincoln.a.baxter@bankofamerica.com>
Date: Sat, 23 Oct 2004 15:27:01 -0700

    On Mon, 2004-10-18 at 10:16, BAXTER, LINCOLN A wrote:
    > Most people with experience with Oracle know that opening oracle connections
    > is SLOW!
    >

    Really? I've never noticed. Unless I'm connecting to a
    database over a slow WAN.

    Here's a connection time to a database on a laptop through
    an 811g network, from a linux server:

    time sqlplus system/system@ts50 @s.sql
        0.38s real 0.04s user 0.02s system

    The actual connection time is much faster, this login has
    to query some DD tables.

    The point is, if the connections are slow, it can be corrected,
    provided the bandwidth is there.

    This is not the correct forum to determine that.

    Try Oracle-L at freelists.org.

    Jared

  • Next message: Ron Savage: "Re: binding multiple values and retain blanks"

    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: Multiple Oracle clients in same code - no usernames needed
      ... You might get away with this with an 9 client and if memory serves me ... In all cases the connections have to 'external' - No name or password ... The mechanism changed to the Oracle wallet in 10 for external ... the 2 oracle client libs will export a lot of the same ...
      (perl.dbi.users)
    • Re: Multiple Oracle clients in same code - no usernames needed
      ... You might get away with this with an 9 client and if memory serves me correctly it can connect both wallet and the old 8 way ... In all cases the connections have to 'external' - No name or password ... The mechanism changed to the Oracle wallet in 10 for external ... the 2 oracle client libs will export a lot of the same ...
      (perl.dbi.users)
    • 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)