Re: avg_row_len
From: Timo Raitalaakso <rafu_at_iki.fi>
Date: Thu, 08 Mar 2012 23:08:02 +0200
Message-ID: <4F591FB2.90600_at_iki.fi>
Date: Thu, 08 Mar 2012 23:08:02 +0200
Message-ID: <4F591FB2.90600_at_iki.fi>
The estimate would be something like your formula. Check also LAST_ANALYZED and does NUM_ROWS match count(*).
http://docs.oracle.com/cd/E11882_01/server.112/e25513/statviews_2117.htm#i1592091
|AVG_ROW_LEN*| |NUMBER| Average length of a row in the table (in bytes)
How full are the used column data types populated? Does_ALL_TAB_COLUMNS
AVG_COL_LEN match DATA_LENGTH
_http://docs.oracle.com/cd/E11882_01/server.112/e25513/statviews_2103.htm#I1020277
Will the future 600k row be poplated with similar data? You will not
know. But it is an estimate.
-- Timo Raitalaakso http://rafudb.blogspot.com 8.3.2012 22:43, Zelli, Brian kirjoitti:Received on Thu Mar 08 2012 - 15:08:02 CST
> So I can see that the average row length in my table is 263. Is that bytes? And if I want to estimate another 600,000 rows I multiply the 600,000 by 263?
>
> ciao,
> Brian
>
-- http://www.freelists.org/webpage/oracle-l