Well, that depends on what you want. 1) You want to allocate all available space as soon as possible and create lots of work for yourself? Then set pctincrease to 100.
2) You want to make SMON periodically wake up and coalesce extents in your tablespace for some perceived performance or space utilization enhancement? ( there isn't one ). Set pctincrease to 1. 3) You want to do things more interesting than deal with space management issues? Set PCTINCREASE to 0, create all tables or indexes in the tablespace with the same sized extents, keep an eye on the amount of space free and forget about it. Better yet, use LMT's. Jared "Seema Singh" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/05/02 02:40 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: TABLESPACE PCTINCREASE? Hi WHAT will be good value for PCTINCREASE Parameter at tablespace level? Zero,100 or 1 Thx -Seema _________________________________________________________________ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).