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 Fri May 19 2000 - 00:00:00 CDT
