Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle8i - MS Access linking delay
Hi
It seems to me that is due to the fact that during linking Access queries
database dictionary to retreive information about table's fields. Try
optimize that moment. Sometimes deleting statistics in schema SYS can help.
Oleg Fedorenkov
Niall Litchfield <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:8g388r$2v1$1_at_soap.pipex.net...
> try upgrading the client software, and ODBC drivers to those supplied with
> 8i. These will still access v7 db's if you have some of those too
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "Don Thomson" <dthomson_at_zack.fammed.wisc.edu> wrote in message
> news:m3em738w1q.fsf_at_zack.fammed.wisc.edu...
> > We have our clinical warehouse currently running on 7.3.3.4. A few of
> > our key users use MS Access to run queries, etc. There haven't been any
> > problems until we looked into upgrading to 8.1.5.
> >
> > Now when we try to "link" from Access to an Oracle(8.1.5) table, the CPU
on
> > oracle goes sky high. Where a table use to link in under a minute on
7.3.3.4,
> > it is now taking 10 minutes.
> >
> > In running the statistical measurements [utlestat] on each of the
> > two instances when the table is linked I find the following measures:
> >
> > 7.3.3.4 8.1.5
> > cpu 2095 46063
> > bytes from sqlnet 25277 87644
> > parse cpu 1984 45973
> >
> > ANY SUGGESTIONS WOULD BE GREATLY APPRECIATED!!!!!
> > --
> > ----- Alice Erickson -------------------- Department of Family
Medicine --
> > aerickso_at_fammed.wisc.edu 263-3475 777 S. Mills Street Madison, WI
53715
>
>
Received on Sun Jun 04 2000 - 00:00:00 CDT