thank you. new project for me, so if im going to argue with someone who has been here for a while... want to be safe. > > From: Gaja Krishna Vaidyanatha <[EMAIL PROTECTED]> > Date: 2003/07/01 Tue PM 02:25:00 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: Should percent increase higher than 0 in 817? > > Greetings, > > Non-zero PCTINCREASE causes unnecessary free space > fragmentation in your tablespaces and should be > avoided. Especially in 8.1.7, where there is no need > for this, given that locally-managed tablespaces are > supported, where PCTINCREASE is NOT even relevant. If > you use > > One of the historical reasons for having a non-zero > PCTINCREASE in the Oracle6 and Oracle7 days, was to > urge SMON to automatically coalesce free space, at the > end of the file, especially after an object is > dropped. In 7.3, the alter tablespace XXX coalesce > command was introduced, which provided on-demand > coalescing even with PCTINCREASE at 0. > > If you have dictionary-managed tablespaces try to > convert to locally-managed tablespaces. Otherwise, use > a PCTINCREASE of 0, use uniform extent sizes at the > tablespace and DO NOT use extent-sizing at the > object-level. > > > Cheers, > > > Gaja > > --- [EMAIL PROTECTED] wrote: > > Everything I have seen says no. I did the following. > > > > Set PCTINCREASE = 0 > > Set my initial and next extents to 5m so they are > > uniform. A woman I work with swears there is Oracle > > documentation that in 817 PCTINCREASE should be > > greater than 0 because the default is 50. > > > > > > ORA-03232 unable to allocate an extent of string > > blocks from tablespace string > > > > Cause: An attempt was made to specify a > > HASH_MULTIBLOCK_IO_COUNT value that is greater than > > the tablespace's NEXT value. > > > > Action: Increase the value of NEXT for the > > tablespace using ALTER TABLESPACE DEFAULT STORAGE or > > decrease the value of HASH_MULTIBLOCK_IO_COUNT. > > > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.net > > -- > > Author: <[EMAIL PROTECTED] > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 > > http://www.fatcity.com > > San Diego, California -- Mailing list and web > > hosting services > > > --------------------------------------------------------------------- > > 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). > > > ===== > > > __________________________________ > Do you Yahoo!? > SBC Yahoo! DSL - Now only $29.95 per month! > http://sbc.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Gaja Krishna Vaidyanatha > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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). >
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
