Re: alter table pctfree question ?

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: 11 Jan 2002 23:35:44 -0800
Message-ID: <a8aed4.0201112335.6dd2b686@posting.google.com>

tedchyn_at_yahoo.com (Ted Chyn) wrote in message news:<44a19320.0201111738.336aa6af_at_posting.google.com>...
> all,
>
> Table A with pctfree 10% with x number of blocks. pctfree was
> altered to 30%. now table contain y number of blocks.
>
> Is there a way finding out there are x number of blocks with pctfree of 10 and
> y-x number of blocks with pctfree of 30 ?
>
> thnx
> ted chyn

Okay ... Now When PCTFREE is Changed It will Start Affecting all Blocks in the Table. So Let us say u have 10% PctFree for 20 Blocks and u Change that to 30% Then the effect is iimd in the sense all the blocks whose Free space is less than 30% is moved of the Freelist.

So There is no avenue to find what u need.

HTH Regards,
Ganesh R Received on Sat Jan 12 2002 - 01:35:44 CST