Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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 ?Received on Wed May 24 2000 - 01:50:13 CDT
![]() |
![]() |