RE: AVG_ROW_LEN in sys.dba_tables

From: Srinivasan Subramanian kandallu <srinivasan.kandallu_at_wipro.com>
Date: Wed, 24 May 2000 13:04:33 +0530
Message-Id: <10507.106483@fatcity.com>

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_at_inf.com] Sent: Wednesday, May 24, 2000 12:20 PM
To: 'ORACLE-L_at_fatcity.com'; 'oracledba_at_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_at_quickdoc.co.uk to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk Received on Wed May 24 2000 - 02:34:33 CDT