Message-Id: <10507.106483@fatcity.com>
From: "Srinivasan Subramanian kandallu" <srinivasan.kandallu@wipro.com>
Date: Wed, 24 May 2000 13:04:33 +0530
Subject: RE: AVG_ROW_LEN in sys.dba_tables

Try this.

select sum(bytes) INTO sbytes from dba_segments
where segment_name = 'TABLE_NAME'

select count(*) into recount from TABLE_NAME;

avg_rowsize = sbytes / recount;

normally it matches with AVG_ROW_LEN on compute statistics

Srini



-----Original Message-----
From: VIVEK_SHARMA [mailto:vivek_sharma@inf.com]
Sent: Wednesday, May 24, 2000 12:20 PM
To: 'ORACLE-L@fatcity.com'; 'oracledba@quickdoc.co.uk'
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 ?




--------
If you're bored, then visit the list's website: http://www.lazydba.com
(updated daily)
to unsubscribe, send a blank email to oracledba-unsubscribe@quickdoc.co.uk
to subscribe send a blank email to oracledba-subscribe@quickdoc.co.uk