Home -> Usenet -> comp.databases.oracle -> Weird Oracle Performance Problem

Weird Oracle Performance Problem

From: Jon Leatherwood <leatherwoodj_at_goalamo.com>
Date: 18 Jul 2001 07:31:39 -0700
Message-ID: <d8008ef7.0107180631.743b94c8_at_posting.google.com> 






We've come across a perplexing problem.  We developed an application
using VB 6 w/ sp5 which connects to an Oracle 8.1.7 instance using the
Oracle ODBC Driver.  On any of the 4 development machines used by our
group, the application connects quickly and all queries perform
well(return data quickly).  When we install the package onto a test
machine, the connection is still made quickly; however, the
performance of queries drop dramatically..(on development most queries
returned data in under 3 seconds..on test machines..same queries take
on average 30secs or more).   We've checked tnsnames, odbc
configurations and registry settings and can not find any difference
in settings from development enviroment to testing enviroment.  Under
both enviroments, the application is connecting to the same instance
of oracle and our development enviroment even has more hops to the
oracle instance then the test machine.  Can anyone give any possible
suggestions on avenues of investigation (or a possible solution).



Thanks,


Jon
Received on Wed Jul 18 2001 - 16:31:39 CEST












Original text of this message