Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re:AVG_ROW_LEN
ED,
I do not believe that the AVG_ROW_LEN column contains any thing other than the actual average row length. At least comparisons of the avg(vsize()+vsize()...) and AVG_ROW_LEN bear that out.
Dick Goulet
____________________Reply Separator____________________Subject: AVG_ROW_LEN
The value of AVG_ROW_LEN in DBA_TABLES is populated by analyzing a table. This value is supposed to represent the average size of a row including overhead.
Question: Does the value AVG_ROW_LEN include both the byte length overhead and the row header or just the byte length overhead?
I ask because I'm trying to adjust non-clustered table sizing calculations that were based on the assumption that row length would be calculated using vsize(column_name) and manually calculating the overhead (i.e., ORACLE8 DBA Handbook Appendix A).
Thanks in advance for your help,
Ed
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=windows-1252" http-equiv=Content-Type>
<META content="MSHTML 5.00.2314.1000" name=GENERATOR></HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>The value of AVG_ROW_LEN in DBA_TABLES is populated by
analyzing a table. This value is supposed to represent the average size of
a row including overhead.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>Question: Does the value AVG_ROW_LEN include both the
byte length overhead and the row header or just the byte length overhead?
</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>I ask because I'm trying to adjust non-clustered
table sizing calculations that were based on the assumption that row length
would be calculated using vsize(column_name) and manually calculating the
overhead (i.e., ORACLE8 DBA Handbook Appendix A).</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>Thanks in advance for your help, </FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>Ed</FONT></DIV></BODY></HTML>
Received on Fri Jul 07 2000 - 14:08:36 CDT