Re: large SORT_AREA_SIZE usefullness

> the queries which used the larger sort_area_size
> actually ran slower

Why don't you run a trace for the small sort_area_size, do the same with the larger sort_area_size, and then submit the trace files to that web site http://www.unal-bilisim.com/products/itrprof/itrprof.html to see what analysis and advice you get.

I'm sure many of the people on this list are curious about this itrprof tool and would be interested in hearing if it helps you answer this question. You could probably put the output up to the list and get advice, especially since the guy who runs the site is on this list. I'd love to see a real-life example of this tool in action.

• Greg

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Greg Moore
  INET: sqlgreg_at_pacbell.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).