-
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
-
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 .....;
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|