Re: Sort area size

From: Joel Garry <joel-garry_at_home.com>
Date: 12 Jan 2005 17:24:52 -0800
Message-ID: <1105579491.968134.300660@f14g2000cwb.googlegroups.com>

Matthias Hoys wrote:
> >
>
> If there are specific reporting batches which need more memory for
sorting,
> you could always change the sort area size "ad hoc" with "alter
session set
> sort_area_size=...".
>

Yeah, Niemec always likes to tell developers to make friends with their dba's by setting sort_area_size=2000000000 :-)

For some values of "always" - some systems do not allow passthroughs of sql to their OCI code...
jg

-- 
@home.com is bogus.
http://www.aaml.org/MMPI.htm

Received on Wed Jan 12 2005 - 19:24:52 CST