Re: DBA Question - Finding out ACTUAL space used in 6.x

In a previous article, janet_at_halibut.nosc.mil (Janet M. Walker) says:

>Are there any ORACLE 6.xx DBAs out there with utilities or
>ways to find out just how much space WITHIN an extent is
>actually being used?

   The following query is usually reliable for determining the number of blocks in a table segment which actually contain rows:

   SELECT COUNT(DISTINCT SUBSTR(ROWID, 1, 8))       FROM my_table;

   This can be thrown off if you have a lot of chained rows.

   I don't know of any similar trick for index segments.

-- 
   - Doug Harris
     Database Administrator,
     System Development Division,
     Statistics Canada             ### Standard Disclaimer Applies ###