AVG_ROW

From: Ed Bittel <ebittel_at_yahoo.com>
Date: Fri, 7 Jul 2000 13:25:15 -0700
Message-Id: <10551.111460@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_02FA_01BFE816.C980CFD0 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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? =20

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,=20

------=_NextPart_000_02FA_01BFE816.C980CFD0 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Dwindows-1252" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR></HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>The value of AVG_ROW_LEN in DBA_TABLES is populated =
by=20
analyzing a table.  This value is supposed to represent the average = size of=20
a row including overhead.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Question:  Does the value AVG_ROW_LEN include =
both the=20
byte length overhead and the row header or just the byte length = overhead? =20
</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I ask because I'm trying to adjust non-clustered=20
table sizing calculations that were based on the assumption that = row length=20
would be calculated using vsize(column_name) and manually calculating = the=20
overhead (i.e.,  ORACLE8 DBA Handbook Appendix A).</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Thanks in advance for your help, </FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Ed</FONT></DIV></BODY></HTML>

------=_NextPart_000_02FA_01BFE816.C980CFD0--

Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger. Received on Fri Jul 07 2000 - 15:25:15 CDT