RE: 11gr2 sql issue

  • From: Michael McMullen <ganstadba@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 9 Nov 2011 13:33:06 -0500

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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Kumar Madduri
Sent: Wednesday, November 09, 2011 8:43 AM
To: Mark W. Farnham
Cc: greg@xxxxxxxxxxxxxxxxxx; 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-l


Other related posts: