Re: How to find the size of a table?

Hello David,

there is a package calls dbms_space (or something like that) that contains a procedure to calculate the physical storage needs of DB objects (table, indexes, ...). The results are pretty correct as far as I can judge (We did some research in that area).
For single rows use the VSIZE operator, but I think someone else already suggested that.

HTH
  Jörg

david_petit_at_yahoo.com schrieb:

> Hello all,
>
> I have two questions about to determine the size of a table.
>
> 1) Is it possible to find the storage space (in bytes) of a table? And
> how accurate it is?
>
> 2) Is it possible to find the storage space (in bytes) of a set of rows
> in a table? e.g. I want to know the storage space for the following set
> of records
>
> select * from testing_table where id = 10
>
> Thanks,
> Daivd
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Nov 12 1999 - 02:42:00 CST