A few suggestions:
- upgrade to 8.1.7.3 client and OLEDB provider (download patches from
MetaLink). See if that makes a difference.
- Add some debugging to the stored procedure (for example, log the IP
of the client and time elapsed using dbms_utility.get_time on entry and
on exit) - see if there are any differences in sp execution speed depending
on client connected (I doubt it, but if there is any significant difference,
you will need to debug the sp and try to figure out what induces it).
- This can be network transport problem - if it takes the same time to
execute the procedure, and significantly different time to retrieve the
recordset (provided it is the same), then the difference in response times
should be accounted for network transport.
- This can be client hardware (most probably insufficient memory).
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Mark Wallace" <markdw71-No_at_S-p-a-m-hotmail.com> wrote in message
news:Juis8.5$Re4.671_at_news.lhr.globix.net...
> We are having the following problem...
>
> When using ADO to call a PL/SQL package that returns a recordset from the
> oracle database, the call takes excessively long, but only on one of our web
> servers!!
> On another web server with the same software setup, i.e. same service packs,
> same oracle client etc, etc the call is almost instantaneous.
> I am have uninstalled, re-installed ...
> service packs...
> Oracle client...
> our software...
> numerous times to see if I could track it down. No luck.
>
> Also when doing standard select queries down to the database (also with ADO)
> it all works great.
> It is just when try to call a PL/SQL package that the one server is hugely
> slower that the other.
>
> Any help would be greatly appreciated.
>
> Summary of our setup :
> ==========================================================
> Client Machine :
> Oracle Client 8.1.7
> OraOLEDB provider 8.1.7.2 (latest version downloaded from oracle)
> IIS 4
> Win NT4 server with service pack 6a
>
> Server Machine :
> Oracle 8.1.6
> ==========================================================
>
> Regards
> Mark
>
>
Received on Wed Apr 10 2002 - 01:20:06 CDT
