Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sql connect got slow

Re: sql connect got slow

From: Ed Zappulla <zappullae_at_rcn.com>
Date: Mon, 15 Jan 2001 09:02:51 -0500
Message-ID: <93uvqj$t5b$1@bob.news.rcn.net>

Here's more info

SQLLDR is also slow connecting.

Once connected, SQLPLUS, connects fast to the same data base and connects at normal speed to other data bases on other servers.

jdbc connections connect at a normal speed..

Everything else on the machine appears to work properly.

any ideas?

"Ed Zappulla" <zappullae_at_rcn.com> wrote in message news:93qg28$gns$1_at_bob.news.rcn.net...
> Hi, I just upgraded to win2k pro and resinstalled ora 8.1.6 Enterprise.
>
> Everything works fine but it looks like SQLPLUS and all db connection take
 a
> lot of time to connect initialy. Then thier fine.
>
> My guess its a TCP/IP time 75 sec out.
>
> Any ideas as to what configuration I need to change to make the connection
> quick?
>
> ...ed
>
>
>
>
>
Received on Mon Jan 15 2001 - 08:02:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US