Oracle Database Discussions

Hi, Experts

Env

#################

Oracle 11.2.0.4

Test case

#################

create table test.obj as

select owner,object_id,created from dba_objects;

-- varchar2,number,date

EXEC DBMS_STATS.GATHER_TABLE_STATS('TEST','OBJ',estimate_percent=>100);

SQL> SELECT COLUMN_NAME,AVG_COL_LEN FROM DBA_TAB_COL_STATISTICS WHERE OWNER = 'TEST' AND TABLE_NAME='OBJ';

COLUMN_NAME                    AVG_COL_LEN

------------------------------ -----------

OWNER                                    5

OBJECT_ID                                5

CREATED                                  8

SQL> SELECT AVG(LENGTHB(OWNER)),AVG(LENGTHB(object_id)),AVG(LENGTHB(created)) FROM TEST.OBJ;

AVG(LENGTHB(OWNER)) AVG(LENGTHB(OBJECT_ID)) AVG(LENGTHB(CREATED))

------------------- ----------------------- ---------------------

         3.91366657              4.24439214                     9

How to calculate avg_col_len ?

Thanks in advance....