Re: analyze

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:                      <->
<->                                                               <->
<->             http://homepage.interaccess.com/~akaplan          <->
<->                                                               <->
<->             email: akaplan_at_interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Sudheer Tummala (sut_at_ordinal.micro.lucent.com) wrote:
: I am using ANALYZE TABLE <table_name> 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
: ***********************************
Received on Fri Sep 26 1997 - 00:00:00 CDT