Average Row Length

Hi Experts ,
 Could any one tell me whats is the Average Row length of my table how can we caluculate it . I have the following table.
 
  SQL> DESC MYTABLE ;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
A            NOT NULL NUMBER
B            NOT NULL NUMBER
C            NOT NULL NUMBER
D            NOT NULL NUMBER
E            VARCHAR2(20)
F            NOT NULL VARCHAR2(20)
G            NOT NULL VARCHAR2(15)
H            NOT NULL VARCHAR2(20)
I            NUMBER
J            CHAR(1)
K            CHAR(1)
L            DATE

Regards
ratnaprasad123Asked:
Who is Participating?
 
jrb1Connect With a Mentor Commented:
You can't tell just from this.  The answer is based on the data in the table.  So, if column F is always length 1, the average row length will be different than if it is always 20.  Luckily, Oracle will tell us the answer.

First do:

analyze table mytable compute statistics;

Then

select avg_row_len from user_tables where table_name = 'MYTABLE';
0
 
ratnaprasad123Author Commented:
Thank you expert .

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.