> 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).