Re: Oracle Table Space

From: Andreas Polke <Andreas.Polke_at_t-online.de>
Date: 8 Dec 1998 21:12:22 GMT
Message-ID: <74k4nm$i3r$1_at_news00.btx.dtag.de>


But this reveals only the allocated extents and not the truly occupied space. A workaround would be analyzing the table and afterwards multiplying the average row length with the number of rows.

James A. Johnson wrote:
>
> You can query dba_segments and give it the table name.
>
> NeedaHoliday wrote:
>
> > Does anyone know the Unix command to determine how much space a table
> > has used.
Received on Tue Dec 08 1998 - 22:12:22 CET

Original text of this message