Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: table size
Thierry Poels wrote:
> Hi,
>
> User_Tables, DBA_Tables and All_Tables only show the initial extent
> and the
> current next extent, but don't show the current size of your table.
> You need to sum the extents in DBA_Extents (or ALL_..., User_...) :
>
> Select Segment_Name, Sum(bytes), Sum(Blocks)
> From User_Extents
> where Segment_Name = 'your_table_name'
>
> greetings,
> Thierry Poels ( Thierry.Poels_at_vab.be )
> DBA & Unix System Manager for VTB-VAB
> http://www.vab.be
>
> Fei Sha wrote in message <714dvs$g93$1_at_venus.uvsq.fr>...
> >Hi everyone,
> > How to know the size of a table in Mb or number of blocks?
> >Thank!
> >
> >Fei
Select Segment_Name, Sum(bytes), Sum(Blocks)
From User_Extents
where Segment_Name = 'your_table_name'
-- forgot this line below
group by segment_name
Received on Wed Oct 28 1998 - 11:07:47 CST