Re: Smart way to calculate size of a table!

maro_at_gbg.ifsab.se (Magnus Rosenquist) wrote:
>
> Hello!
>
> Is there someone out there who can give me a clue on how to calculate
>the physical size of a table ?
>
>Perhaps one or a few of the V$-tables ?
>
>I would greatly appreciate any answers to this question.
>
> TIA
>
> /Magnus Rosenquist
> maro_at_gbg.ifsab.se
>
>
>
hi,
no v$ table will give this data,
you have two solutions:
1- to compute the allocated space (not the used one), use the

    dba_extents (or user_extents) using the table name in segment_name. 2- to compute the used blocks, select count(distinct substr(rowid,1,8)) from ....

   and * db_block_size (again, this will give an approximate answer, as it    does not account for unused space in blocks).

hth Received on Fri Feb 09 1996 - 00:00:00 CET