Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> AVG_ROW_LEN in sys.dba_tables

AVG_ROW_LEN in sys.dba_tables

From: VIVEK_SHARMA <vivek_sharma_at_inf.com>
Date: Wed, 24 May 2000 12:20:13 +0530
Message-Id: <10506.106473@fatcity.com>


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 ?
Received on Wed May 24 2000 - 01:50:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US