Re: object size?

ptsao_at_sequeltech.com wrote:
>
> Hi, All,
>
> How can I figure out the size of an object? for example,a table's size.
>

If the tables are small, do something like

ANALYSE TABLE table_name COMPUTE STATISTICS

... for each table. After that, Use something like this:

SET linesize 1000;
SELECT

                SUBSTR(table_name,1,15) "TABLE",
                SUBSTR(PCT_FREE,1,5) "%FREE",
                SUBSTR(PCT_USED,1,5) "%USED",
                SUBSTR(INI_TRANS,1,6) "ITRANS",
                INITIAL_EXTENT,
                NEXT_EXTENT,
                SUBSTR(MIN_EXTENTS,1,6) "MINEXT",
                SUBSTR(PCT_INCREASE,1,4) "%INC",
                NUM_ROWS,
                BLOCKS,
                AVG_SPACE,
                SUBSTR(CHAIN_CNT,1,6) "CHNCNT",
                AVG_ROW_LEN
        FROM dba_tables WHERE owner = 'scott';

Rupesh Received on Fri Feb 07 1997 - 00:00:00 CET