"Buck Turgidson" <jc_va_at_hotmail.com> wrote in message
news:5b0939ec23ccd5ad695f12f421943a2c_at_news.teranews.com...
> 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.
>
>
By querying v$sort_usage while running the long-running query in another
session, it appears to be done in the remote db. Can someone confirm my
conclusion?
Received on Tue Oct 07 2003 - 07:38:34 CDT
