RE: 11gr2 sql issue
From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Wed, 9 Nov 2011 13:33:06 -0500
Message-ID: <SNT130-ds156F2F347FA8C70C7CEDB2A6DF0_at_phx.gbl>
When dealing with db link slowness I like to hop onto the db where the data resides and fire it off directly and run a plan. This gives me the response time of what it would be like without db links. I also create a view on the source server with the query and then just query the view across the db link. This ensures that all the work is done on the source server. Tune on the source, not via a db link.
Date: Wed, 9 Nov 2011 13:33:06 -0500
Message-ID: <SNT130-ds156F2F347FA8C70C7CEDB2A6DF0_at_phx.gbl>
When dealing with db link slowness I like to hop onto the db where the data resides and fire it off directly and run a plan. This gives me the response time of what it would be like without db links. I also create a view on the source server with the query and then just query the view across the db link. This ensures that all the work is done on the source server. Tune on the source, not via a db link.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Kumar Madduri
Sent: Wednesday, November 09, 2011 8:43 AM
To: Mark W. Farnham
Cc: greg_at_structureddata.org; oracle Freelists
Subject: Re: 11gr2 sql issue
Hi
Hope the attachments with the explain plans makes it (it was too big to be
pasted).
With OFE set to 11.1.0.7 REMOTE step is step 22 and with the OFE set to
11.2.0.2 REMOTE step is 39.d
If I use the ordered hint the remote step is moved further above. This
(ordered hint sql) seems to be the fastest. I am trying to understand
these differences
Thank you
Kumar
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 09 2011 - 12:33:06 CST