avg_row_len - does it include long raw
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: avg_row_len - does it include long raw

  1. #1
    Join Date
    Feb 2001
    Posts
    128

    avg_row_len - does it include long raw

    Hi,

    Does the value in avg_row_len(dba_tables) include the long raw column ...
    If not, how do i find the avg-row-len for a table with long raw's..

    Thanks
    Vj

  2. #2
    Join Date
    Jun 2005
    Posts
    31
    Quote Originally Posted by Nugpot
    Does the value in avg_row_len(dba_tables) include the long raw column ...
    Try:

    SQL> select column_name, vsize(columname) from tablename .....;

    Quote Originally Posted by Nugpot
    If not, how do i find the avg-row-len for a table with long raw's..
    Divide the size of the table by the number of rows.

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