avg_row_len zero ! urgent
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: avg_row_len zero ! urgent

  1. #1
    Join Date
    Jul 2000
    Posts
    119

    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

  2. #2
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi,
    what is the num_rows -param of this tables
    are they emtpy?

    Orca

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    are they empty?
    "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

  4. #4
    Join Date
    Jan 2001
    Posts
    3,131
    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.

  5. #5
    Join Date
    Jul 2000
    Posts
    119
    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

  6. #6
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    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

  7. #7
    Join Date
    Jul 2000
    Posts
    119
    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

  8. #8
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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 09: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

  9. #9
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    if you dont have any rows how do you suppose to calculate the average row length?

    common sense

  10. #10
    Join Date
    Jan 2001
    Posts
    3,131
    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
  •  



Click Here to Expand Forum to Full Width