浅析DBA_TAB_COLUMNS，DBA_TAB_COL_STATISTICS，DBA_TAB_COLS的关系

DBA_TAB_COLUMNS： DBA_TAB_COLUMNS describes the columns of all tables, views, and clusters in the database。描述了所有表、视图、簇的列
DBA_TAB_COL_STATISTICS ： DBA_TAB_COL_STATISTICS contains column statistics and histogram information extracted from “DBA_TAB_COLUMNS”.从DBA_TAB_COLUMNS中获取的统计信息，oracle有意将此视图制作成执行收集统计信息后的列统计信息视图
DBA_TAB_COLS： DBA_TAB_COLS describes the columns of all tables, views, and clusters in the database. This view differs from "DBA_TAB_COLUMNS" in that hidden columns are not filtered out.看下表定义就知道什么意思了
查看DBATABCLOUMNS视图
SQL> select dbms_metadata.get_ddl('VIEW','DBA_TAB_COLUMNS','SYS') from dual;


DBMS_METADATA.GET_DDL('VIEW','DBA_TAB_COLUMNS','SYS')
--------------------------------------------------------------------------------


  CREATE OR REPLACE FORCE VIEW "SYS"