Re: Heterogenous Service much slower in Oracle 9 than in Oracle 8

From: EdStevens <quetico_man_at_yahoo.com>
Date: 17 Aug 2006 14:06:34 -0700
Message-ID: <1155848794.680020.182230@75g2000cwc.googlegroups.com>

Ray Saltrelli wrote:
> My database allows users to query data external to Oracle using
> Heterogeneous Services' OLE interface. I had a query that did 4 joins
> on this external data that would complete in roughly 10 of 15 minutes
> in Oracle 8.1.7.4. Now that I am using Oracle 9.2.0.6, the same query
> on the same data takes almost 2 hours! I have been able to determine
> that the bottle neck is in Oracle but I do not know where or how. Does
> anyone know why this is happening and if there is anything I can do
> about it? Thanks.

Sounds like a perfect candidate to capture a 10046 trace and see where it is spending its time. Received on Thu Aug 17 2006 - 16:06:34 CDT