Re: PCTFREE

From: John Chiu <johnymc_at_netscape.net>
Date: Thu, 9 Dec 1999 06:24:52 -0500
Message-ID: <82o3ci$n3d$1@news2.tor.accglobal.net>

Yann Ming <ylew_at_my.lhsgroup.com> wrote in message news:384f24d3_at_news.lhsgroup.com...
> Hope someone could help me on this.
>
> What is PCTFREE?

PCTFREE defines the percentage of free space in a database block when you allocate a database block in your table/index.

> How would the PCTFREE size impact on the database performance?

allow the database row to expand in the future.

> How would I know what is the best size for PCTFREE?
>

no definite answer. It depends on the application/nature of your table/index.

HTH John Chiu Received on Thu Dec 09 1999 - 05:24:52 CST