Re: what SQL will find data size used in Database?

I was told that the command

>sp_spaceused Table_name

will give this information for sybase. using the above stored procedure. I need now to find how to do the same using Oracle.

Nasser

In article <6s7elc$r4n_at_drn.newsguy.com>, nasser_at_apldbio.com says...
>
>hello,
>
>This is for Oracle and Sybase.
>I'am using JDBC to acces database. I'd like to find how much space (in
>bytes) is used by a row in a table. I can offcourse look at the datasize
>of each column (from the schema). But for things like strings, I am not
>sure if the database will reserve the full string size, even if one has
>half of it used for a particular row.
>
>any ideas on this? is there some SQL trick to count byte size used by a row
>other than looking at the schema and looking at datatype for each column?
>
>thanks,
>Nasser
Received on Fri Aug 28 1998 - 00:00:00 CDT