Re: Where Is Sort Done on Dblink?

Where the sort is done all depends on what query is actually sent to the remote database. First, do an explain plan on your query. If you see SORT returned, then the sort is being done locally. When you query the PLAN_TABLE, query the OTHER column as well. For the line in the Explain Plan that says "REMOTE", the OTHER column shows the exact query sent to the remote database. Take that query to the remote database and do an explain plan there. Is the sort being performed there? That is how you figure it out.

HTH,
Brian

Buck Turgidson wrote:
>
> We are selecting from large_table_at_remotedb and ordering by a column. Is
> there sort done in the local SGA or remote SGA? We want to increase the
> sort_area_size, but we are not sure in which instance to do it.

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"