Sudheer,
The avg_row_len does include header data. I did an experiment:
1) Create a table with one column, varchar2(100)
2) Insert 1000 records with a five-character string "xxxxx"
3) Analyze the table
4) Select the avg_row_len from all_tables
What I found was that the average length was 9. The string was 5
characters, so there were 4 additional "overhead" bytes.
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 110+ Oracle tips, visit my Web Page: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Sudheer Tummala (sut@ordinal.micro.lucent.com) wrote:
: I am using ANALYZE TABLE COMPUTE STATISTICS;
: and then selecting table_name, avg_row_len from dba_statistics to get
: the average lrow length in each table.
:
: What I want to know is, does the avg_row_len column in dba_tables inlude
: Header space per row also?
:
:
: --
: ***********************************
: Sudheer Tummala
: ***********************************
Back to Ari Kaplan's Home Page