Re: Oracle 8.1.7 Response Times

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Tue, 15 Jan 2002 15:23:17 +0000
Message-ID: <3C444965.2DBC3FFB@exesolutions.com>

Your statement "appears to process the queries the same." begs the question have you run an Explain Plan and TKProf?

I could say many rude things about MS Access by itself. Even more using it to front-end Oracle. But somehow I suspect your statement, above, is pure untested assumption.

Daniel Morgan

Craig Muth wrote:

> I have an application written in MS Access that for most queries gets response
> times in the seconds when using Oracle 7.3.4. When using Oracle 8.1.7 I get
> response times in the minutes for the same queries. Not all queries have the
> same response time problems. the Oracle database is at 8.1.6 and appears to
> process the queries the same.
> The workstation is running Windows NT at SP2, it think, the workstation is a
> PIII, and the memory is 128MB. I know that Access is a problem, but I can't
> rewrite the application yet.
> Has anyone seen this type of a problem and solved it? If so, how have you
> solved it.
>
> Thanks
Received on Tue Jan 15 2002 - 09:23:17 CST