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 -> Memory Sorts

Memory Sorts

From: Roman Gelfand <rgelfand_at_masmid.com>
Date: Fri, 11 Sep 1998 10:21:28 -0400
Message-ID: <6tbbjs$atm$1@news.monmouth.com> 





What is the formula for sort_area_size based on a particular query?



For example, I am doing an ordered select on a view which is a four table
join.  How do you calculate sufficient memory size needed for sort area so
that sort is done  in memory and why?



Thanks,



Roman



Received on Fri Sep 11 1998 - 09:21:28 CDT












Original text of this message













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