'Statistics' Tag

• Statistics

  09月 26, 2009

  DBMS_STATS statistics that are generated include the following: (1) Table statistics(DBA_TABLES and DBA_TAB_[SUB]PARTITIONS) NUM_ROWS Number of rows BLOCKS Number of blocks(Blocks is the number of used data blocks.) AVG_ROW_LEN Average row length(This is the average length of a row in the table in bytes.) /* Global statistics (if requested) User statistics (if requested) Sample size [...]

  posted in Oracle 知识杂记 by | 编辑