Re: Faster index creation
From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Thu, 15 May 2008 09:55:56 -0700 (PDT)
Message-ID: <ec0a66e1-cd4c-4c01-8635-447f8da3722e@x35g2000hsb.googlegroups.com>
Date: Thu, 15 May 2008 09:55:56 -0700 (PDT)
Message-ID: <ec0a66e1-cd4c-4c01-8635-447f8da3722e@x35g2000hsb.googlegroups.com>
On May 14, 5:04 pm, Mladen Gogala <mgog..._at_yahoo.com> wrote:
> On Wed, 14 May 2008 10:53:15 -0700, bdbafh wrote:
> > alter session set workarea_size_policy='MANUAL'; alter session set
> > db_file_multiblock_read_count=128; alter session set
> > sort_area_size=536870912;
>
> Do not do this if the database version is 10.2 or later.
>
> --http://mgogala.freehostia.com
Mladen, has the 5% of pga_aggregate_target for the sort area for a session limitation been lifted?
Also under heavy user load can one session still get the large sort area that the article alludes to? There is no chart that shows any relationship between the expected sort set and how much space Oracle will acquire for the sort.
- Mark D Powell --