avg_row_len zero ! urgent

[launchpad]

All,
I have analyzed the tables today in my database, it's showing me avg_row_len of some of tables 0 !
Can anybody pelase throw some light on this please !
Thanks in advance,.

[Orca777]

Hi,
what is the num_rows -param of this tables
are they emtpy?

Orca

[DaPi]

are they empty?

[Mr.Hanky]

It appears that avg_row_len goes hand in hand with num_rows, if there is no data to be averaged then you will get a 0.

MH


SQL>select owner, table_name,AVG_ROW_LEN, NUM_ROWS
from dba_tables
where owner='X-Mas_poo'
ORDER BY 3

[launchpad]

Yes the tables for which avg_row_len is 0 are empty.

ORACA777: what exactly mean by what is the num_rows of table ??

Thanks

[Orca777]

Hi,
its a column in dba_tables which is written from an analyze on this table

NUM_ROWS                  NUMBER       Y                The number of rows in the table

Orca

[launchpad]

I am checking from dba_tables only,
when I fire table_name, sum(avg_row_len) from dba_tables,
I get some tables with avg_row_len zero and they really6 haev no data in it i.e 0 records.
Why is that ?

[DaPi]

My understanding is that avg_row_len is just that - it is the average real length of the rows, which is less than the maximum because varchar2() only takes the space needed (plus a little bit) unlike char() where trailing spaces are included. If there are no rows this average can't be calculated. I guess it should be NULL not zero!

[pando]

if you dont have any rows how do you suppose to calculate the average row length?

common sense

[Mr.Hanky]

Why is this an "urgent" problem?

MH