Re: INITIAL, NEXT, PCTFREE and PCTUSED

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Sat, 4 Sep 1999 21:13:05 +0200
Message-ID: <936472432.14195.0.pluto.d4ee154e@news.demon.nl>

Hi Jack,

Please refer to the Oracle Server Administrators guide, space estimization for schema objects, for formulas to calculate the necessary space. The value next largely depend on the growth of a table. The PCTFREE depends on if you expect the data to be updated and to increase in size. The PCTUSED can be altered when you want a block sooner on the free list.

Hth,

--
Sybrand Bakker, Oracle DBA

Jack Zhu <jackzhu_at_monmouth.com> wrote in message news:936455122.1061762385_at_news.monmouth.com...
> For creating a table which will store large data and has millions rows,
how to
> determine the proper size of INITIAL, NEXT, PCTFREE, and PCTUSED?
>
> Thanks!
>
>
Received on Sat Sep 04 1999 - 14:13:05 CDT