Finding space-bound objects?

Hi all,

I've looked at several scripts which purport to produce a list of tables, indexes etc. which can't extend within the tablespace, because the largest contiguous piece of free space is less than the NEXT_EXTENT value for the segment.

However, unless I'm not seeing something here, this is too simplistic for the real world isn't it?

What happens if the segment has a PCT_INCREASE value non-zero? Surely in that case the next extent it wants to create will be the size of the last extent it created * (1 + PCT_INCREASE/100) won't it? Or have I misunderstood the meaning of PCT_INCREASE or the way it is implemented?

For example if the table BIGTAB has a PCT_INCREASE value of 50 and has INITIAL_EXTENT and NEXT_EXTENT values of 16384 and 16384 respectively, won't the extents be allocated with these sizes:

16384
16384
24576
36864
55296
etc...

I appreciate that these might not be the exact values, as presumably the real values would have to be multiples of the block size, but you can see the principle.

Any comments or input very welcome!

Regards,

Tim Kearsley
Database Manager,
Milton Keynes Council Received on Tue Apr 30 2002 - 05:52:28 CDT