Re: Oracle 8.1.7 Response Times

Daniel,
I appreciate your understanding. I have said some rude thing about Access myself. Yes, Explain has been run and so has TKProf both show that the database is functioning properly
We found a flag in the SQLNET.ORA file that has bettered the response times. It appears that a Debug flag
was turned on and a debug file was being written. I never saw that file but another development group did.
Once we changed that flag the improvement was fantastic. I don't know if that will fix all of the response time problems.

Thanks for the help.
"Daniel A. Morgan" wrote:

> 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 Thu Jan 17 2002 - 15:57:50 CST