Re: Block count usage by a table

From: Reiner Neumann <reiner.neumann_at_messe.de>
Date: Mon, 6 Jul 1998 11:13:09 +0200
Message-ID: <6nq4fp$7tl$1@mail.messe.de>

easier and accurate will be another way:

analyze table sometable compute statistics;

select table_name, num_rows, blocks, empty_blocks from user_tables where table_name = 'SOMETABLE';

Regards,
Reiner Neumann

johnvue_at_gte.net schrieb in Nachricht <6npf4n$8aa$1_at_news-1.news.gte.net>...
>I see the following query mentioned to find out how many blocks a
>table is using up:
>
>select COUNT(DISTINCT(SUBSTR(ROWID,1,8)||SUBSTR(ROWID,15,4)))
> Blocks_Used
> from sometable;
>
>
>If most/all of the rows are chained/migrated, won't this query be
>inaccurate?
Received on Mon Jul 06 1998 - 04:13:09 CDT