RE: 11gr2 sql issue

From: Michael McMullen <>
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: [] On Behalf Of Kumar Madduri
Sent: Wednesday, November 09, 2011 8:43 AM To: Mark W. Farnham
Cc:; oracle Freelists Subject: Re: 11gr2 sql issue

Hope the attachments with the explain plans makes it (it was too big to be pasted).
With OFE set to REMOTE step is step 22 and with the OFE set to 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

Received on Wed Nov 09 2011 - 12:33:06 CST

Original text of this message