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

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 17 Aug 2006 16:03:02 -0700
Message-ID: <1155855782.284288.53100@p79g2000cwp.googlegroups.com>

EdStevens wrote:
> 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.

I agree with Ed, as this may just be a tuning opportunity rather than a version specific feature condition.

IMHO -- Mark D Powell -- Received on Thu Aug 17 2006 - 18:03:02 CDT