Message-Id: <10506.106473@fatcity.com>
From: VIVEK_SHARMA <vivek_sharma@inf.com>
Date: Wed, 24 May 2000 12:20:13 +0530
Subject: AVG_ROW_LEN in sys.dba_tables

Upon doing "ANALYZE TABLE <table name > COMPUTE STATISTICS" the AVG_ROW_LEN
field gets populated 

	EXAMPLE :-
	select table_name,avg_row_len
	from sys.dba_tables
	where ...
	/ 

	OUTPUT :-
	TABLE_NAME                  AVG_ROW_LEN   
	-------------------------   ------------  
	DAILY_TRAN_DETAIL_TABLE      186            

	What is the Unit of This Field ? Is it BYTES implying 186 BYTES ?
	 
	Anybody Checked HOW Correct this Value is ?