How to determine used blocks in an extent.

From: Roy Varghese <rvarghese_at_ibm.net>
Date: 1997/11/28
Message-ID: <347f4595.0@news1.ibm.net>#1/1

I have a table that has been allocated a very large initial extent. Something like 1.7GB. It is contained in a tablespace of 2 GB. Only an ANALYZE TABLE would show the actual number of blocks which are free or used-up in the extent. However the ANALYZE TABLE command takes quite a long time to complete since there are too many rows in the table.

Can someone suggest a faster way of determining the blocks' usage within the extent?

All answers appreciated. Received on Fri Nov 28 1997 - 00:00:00 CST