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
> ***********************************
>
Received on Sat Sep 27 1997 - 00:00:00 CDT
