Dba_tab_statistics

Understanding Oracle Database Statistics Gathering: A Comprehensive Guide Purpose DBA_TAB_STATISTICS is the view that shows what the optimizer knows about each table: the number of rows, the average row length and the number of data blocks. DBMS_STATS is the package that fills those numbers in. The optimizer reads them …