Re: Faster index creation
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: 14 May 2008 21:04:38 GMT
Message-ID: <482b53e6$0$30640$834e42db@reader.greatnowhere.com>
Date: 14 May 2008 21:04:38 GMT
Message-ID: <482b53e6$0$30640$834e42db@reader.greatnowhere.com>
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.comReceived on Wed May 14 2008 - 16:04:38 CDT