Re: database procedure slow in running from unix client

I would guess the use of a database link is why it is performing poorly .

If you did the reverse (run procedure in sqlplus logged in on NT using a db link to Unix database), you would probably see poorer performance than running the procedure in sqlplus on Unix.

But, then again, running the procedure in sqlplus on NT or Unix while logged into the NT server would probably work with no problem.

Is there a reason in particular that you are using a db link? Why not log on the NT server and not use a db link?

"Glenn MacKay" <glen_mackay_at_yahoo.com> wrote in message news:831d3f98.0205140550.2f525810_at_posting.google.com...
> Hi All,
>
> We are running an Oracle 8.1.7 database on a Windows NT machine. When
> we run a particular stored procedure through SQL*PLUS on a UNIX
> machine the procedure is very slow in running. This same procedure,
> when run through a Windows NT client is extremely fast.
>
> The UNIX machine that we run the procedure on has its own Oracle 8.1.7
> database although we are using a database link to connect our UNIX
> client to the NT Oracle server.
>
> My question is why the discrepancy in performance? The procedure is
> running on the database in both cases. I'm kind of new at this and am
> somewhat perplexed. Any help would be appreciated. Thanks
Received on Wed May 15 2002 - 07:08:05 CEST