Re: size of a table

"maz" <maz_at_savvion.com> wrote in message news:3BC48229.DF95BDFF_at_savvion.com...
> Hello,
>
> is it possible to calculate the amount of space that is being used by a
> table?
> how about a column?
>
> I have looked at some oracle DBA books that nothing is mensioned on this
> topic!
>
> thanx in advance,
>
> -maz
>
> --
> ---------------------Use e-mail. It saves trees----------------------
> Maz Mohammadi Senior Member of the Technical Staff
> mailto:maz_at_savvion.com (408)330-3101
> http://www.savvion.com Savvion Inc.
>
> "Programming today is a race between software engineers striving to
> build bigger and better idiot-proof programs, and the Universe trying
> to produce bigger and better idiots. So far, the Universe is winning."
> -- Rich Cook

You probably bought the wrong dba books

Look at dba_segments for object allocation select vsize(columnname)
from <table>
to get the actual allocation for a column

Hth,

Sybrand Bakker
Senior Oracle DBA Received on Wed Oct 10 2001 - 12:38:47 CDT