Re: database procedure slow in running from unix client

Hi Burt,

Thanks for your response. I was incorrect in the way that our system works. We are actually logging in to the NT server and not using a DB link. So from Unix we open a SQl*PLUS session on the NT server.

I also found out that the SQL*PLUS session has the below setting.

alter session set optimizer_mode = all_rows;

So I'm going to run the procedure with the optimizer_mode at different settings and see what impact this has. Maybe this is what is causing the difference in performance.

Cheers,

Glenn

"Burt Peltier" <burtpelt_at_bellsouth.net> wrote in message news:<xvlE8.220613$tt4.16590828_at_e3500-atl2.usenetserver.com>...
> 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 - 15:06:15 CEST