Re: Oracle 8.1.7 Response Times

Try analysing the tables you're running query against. (dbms_stats package, you can use dbms_stats.gather_schema_stats)

Also, do you use pass-through queries in Access, or you link tables and query them as Access tables?

"Craig Muth" <muth002_at_attglobal.net> wrote in message news:3C44A19B.D1F7C625_at_attglobal.net...
> 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 Wed Jan 16 2002 - 02:06:22 CST