Re: Oracle 8.1.7 Response Times

Andrija,
We have run all of the different tools and have found that the database is not the problem.
Yes, we do have pass-through queries, dynamic queries and about anyother kind of queries that
are available in Access.
We know that displaying the information on the screen is, in some cases, very slow but we understand that
the overall response time problem was approximately 3 percent worse on small queries just bringing back
a small number of rows. Some of the larger queries bring back hundreds of thousands of rows. So you can
imagine what the response times were like.

Thanks for the response

andrija wrote:

> 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 Thu Jan 17 2002 - 16:02:56 CST