> Not clear on last thing you said. > You mean alter session for workarea_size_policy to manual and then > set sort_area_size to what you want for that session? Yes, you can set workarea_size_policy=auto at the system level for regular sessions and for your batch sessions you can set it explicitly to manual + set a bigger sort_area_size. Tanel. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------