Message-Id: <10551.111460@fatcity.com> From: "Ed Bittel" Date: Fri, 7 Jul 2000 13:25:15 -0700 Subject: AVG_ROW_LEN 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 Ed ------=_NextPart_000_02FA_01BFE816.C980CFD0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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.

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

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).

Thanks in advance for your help,

------=_NextPart_000_02FA_01BFE816.C980CFD0-- __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger.