Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Where Is Sort Done on Dblink?

Where Is Sort Done on Dblink?

From: Buck Turgidson <jc_va_at_hotmail.com>
Date: Tue, 07 Oct 2003 12:20:14 GMT
Message-ID: <5b0939ec23ccd5ad695f12f421943a2c@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.
Received on Tue Oct 07 2003 - 07:20:14 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US