Oracle8i - MS Access linking delay

From: Don Thomson <dthomson_at_zack.fammed.wisc.edu>
Date: 2000/05/15
Message-ID: <m3em738w1q.fsf@zack.fammed.wisc.edu>#1/1

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 Mon May 15 2000 - 00:00:00 CDT