Re: analyze

I do not believe that the value stored in avg_row_len contains the header space.
You will have to include the extra bytes for each row header in calculating how
much space n number of rows would require. Regards,

-- 
Phillip Bump
pjbump_at_i1.net

Sudheer Tummala <sut_at_ordinal.micro.lucent.com> wrote in article
<342A8134.7ACF_at_ordinal.micro.lucent.com>...


> I am using ANALYZE TABLE <table_name> COMPUTE STATISTICS;


> and then selecting table_name, avg_row_len from dba_statistics to get

> the average lrow length in each table.

> 

> What I want to know is, does the avg_row_len column in dba_tables inlude

> Header space per row also?

> 

> sut_at_orsunsut.micro.lucent.com

> -- 

> ***********************************

>   Sudheer Tummala

> ***********************************

>