Re: TABLESPACE PCTINCREASE?

From: <Jared.Still_at_radisys.com>
Date: Tue, 05 Feb 2002 16:02:45 -0800
Message-ID: <F001.00406C18.20020205151523@fatcity.com>

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" <oracledbam_at_hotmail.com>
Sent by: root_at_fatcity.com
02/05/02 02:40 PM
Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        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: oracledbam_at_hotmail.com

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: ListGuru_at_fatcity.com (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: Jared.Still_at_radisys.com

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: ListGuru_at_fatcity.com (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).

Received on Tue Feb 05 2002 - 18:02:45 CST