Re: Compute free space in table

Hi Rob,

You can try this ..

spool /tmp/tabsize
select blocks "ALLOCATED BLOCKS",
 count(distinct substr(t.rowid,1,8)||substr(t.rowid,15,4)) "BLOCKS USED",    round(count(distinct
substr(t.rowid,1,8)||substr(t.rowid,15,4))/blocks*100)

   "PCT USED"
  from sys.dba_segments e, &&tablename t  where e.segment_name = upper('&&tablename')    and e.segment_type = 'TABLE'
 group by e.blocks;

Vincent Robine wrote in message <71ddue$jkl$1_at_minus.oleane.net>...
>Hello,
>
>I'm new in ORACLE word, so fell free to assume ignorance,
>
>I'd like to compute the true space occupy by data of a table in a
>tablespaces, not the space allocated by the initiale or next extents
>(free_space). And, of course it would be too simple, I can not start
>statistics on the table to get the true number of row and average size of
>line
>
>All suggestions will be welcome
>
>thanks in advance
>
>Vincent
>
>vrobine_at_capgemini.fr
>vincent.robine_at_capway.com
>vrobine_at_shom.fr
>
>
>

begin 666 Yassir Khogaly.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..DMH;V=A;'D[66%S<VER#0I& M3CI987-S:7(@2VAO9V%L>0T*5$E43$4Z4V5N:6]R($]R86-L92!$0D$-"E1% M3#M(3TU%.U9/24-%.BLT-"@P*3$X,2 T-C T,#0R#0I414P[0T5,3#M63TE# M13HK-#0T,3$Y,#8W-S8-"D%$4CM(3TU%.CL[.SM+96YT.SM%;F=L86YD#0I, M04)%3#M(3TU%.T5.0T]$24Y'/5%53U1%1"U04DE.5$%"3$4Z2V5N=#TP1#TP M045N9VQA;F0-"E523#IH='1P.B\O=W=W+FMH;V=A;'DN9G)E97-E<G9E+F-O M+G5K#0I54DPZ:'1T<#HO+W=W=RYA965U+F]R9RYU:PT*14U!24P[4%)%1CM) M3E1%4DY%5#IY87-S:7) :VAO9V%L>2YF<F5E<V5R=F4N8V\N=6L-"E)%5CHQ <.3DX,3 S,50R,# P,C!:#0I%3D0Z5D-!4D0-"@`` `
end Received on Sat Oct 31 1998 - 14:00:20 CST