-
avg_row_len zero ! urgent
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,.
OCP 8.0, 8i, 9i
-
Hi,
what is the num_rows -param of this tables
are they emtpy?
Orca
-
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
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
I remember when this place was cool.
-
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
OCP 8.0, 8i, 9i
-
Hi,
its a column in dba_tables which is written from an analyze on this table
Code:
NUM_ROWS NUMBER Y The number of rows in the table
Orca
-
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 ?
OCP 8.0, 8i, 9i
-
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!
Last edited by DaPi; 12-19-2002 at 10:35 AM.
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
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
I remember when this place was cool.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|