Re: Summery of all Used Oracle-Blocks

to obtain the number of blocks allocated (A):

   select blocks from dba_segments where segment_name='table_name';

to obtain the number of unused blocks (B):

   analyze table tablename compute statistics;    select empty_blocks from dba_tables where table_name=;tablename';

# of used blocks (including headers) = A - B

HTH John Chiu Received on Thu Nov 11 1999 - 05:40:13 CST