Re: how to get rowsize in bytes for a table.

Hi

Be aware that if you analyze a table the queries that use the analyzed table may slow down DRATICALLY, especially if it is joined with large tables or large views. That is because Oracle uses Cost based optimizer (CBO ) rather Rule based optimizer and all joined tables are analyzed at the time of select statement execution.

Here is another way to get the same thing:

If it is an already populated table, in Oracle 7.3.3, try using

select sum(vsize(col1)) + sum(vsize(col2)) + ....... sum(vsize(colN))

    from table_name;

This will give you the actual size in bytes of Oracle internal representation of all the data records in that table. In other words the size of the table.

Oracleguru
www.oracleguru.net
oracleguru_at_mailcity.com  

Denny Koovakattu <denny_vk_at_my-dejanews.com> wrote in article <7b6la5$gjk$1_at_nnrp1.dejanews.com>...
> Analyze the table and look at the avg_row_len .
>
> Denny
>
> In article <7b5vs4$tji$1_at_nnrp1.dejanews.com>,
> tim.mcconechy_at_runtime.dk wrote:
> > Is there a v$ table which will give me row_size in bytes for a table???
> >
> > Tusind Tak!
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
> >
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
 

>
Received on Fri Feb 26 1999 - 16:27:44 CST