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 storage requirement ?

Re: table storage requirement ?

From: Barbara Kennedy <barbken_at_teleport.com>
Date: Sat, 23 Sep 2000 13:03:21 -0700
Message-ID: <g%7z5.22934$is5.1200717@nntp1.onemain.com>

Analyze the table and do avg row size * row count or do a sum(vsize(column))+sum(vsize(next_column))+..on eaach table if you want the actual data size
<tedchyn_at_yahoo.com> wrote in message news:8qisml$ckd$1_at_nnrp1.deja.com...
> sir,
> for table storage - there is allocated space and high water mark which
> does not really tells me how much space actually used by the rows
> because the percent used and pct free. Is there a way(or procedure)
> finding out how much space actually get used by a table rows ?
>
> thnx in advance
> ted chyn
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Sep 23 2000 - 15:03:21 CDT

Original text of this message

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