Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: table size

Re: table size

From: M. Bhatti <mohammed.bhatti_at_mci.com>
Date: Wed, 28 Oct 1998 12:07:47 -0500
Message-ID: <36374F62.D8F02501@mci.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US