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).
