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,.
Printable View
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,.
Hi,
what is the num_rows -param of this tables
are they emtpy?
Orca
:cool:
are they empty?
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
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
Hi,
its a column in dba_tables which is written from an analyze on this table
Orca:cool:Code:
NUM_ROWS NUMBER Y The number of rows in the table
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 ?
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!
if you dont have any rows how do you suppose to calculate the average row length?
common sense
Why is this an "urgent" problem?
MH