Re: Slow connection

Giganews Newsgroups
Subject: Re: Slow connection
Posted by:  Daniel Morgan (damorg…@x.washington.edu)
Date: Fri, 30 Jan 2004

Matt wrote:

> Hi,
>
> When I connect to the database with "sqlplus system/manager", the
> connection is normal.
> When I connect to the database with "sqlplus system/manager@sid", the
> connection is not normal.
> The time is between 0 and 100000 msec. There is not a big activity on
> the database server.
>
> This test is doing locally on the database server.
>
> Have you got an idea ?
>
> The database is Oracle 7.3.4 on a Alpha 800 server (Tru64 v4.0)
>
> Thanks for your help,
> Matthias

Database links are slow.

But why are you using a db link to connect as SYSTEM? Just get on the
machine.

That you have a Paleolithic version of Oracle is a big problem.

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorg…@x.washington.edu
(replace 'x' with a 'u' to reply)

Replies

In response to

Slow connection posted by m.m…@voila.fr on 30 Jan 2004