Oracle lists the following table statistics in the DBA_INDEXES, USER_INDEXES and ALL_INDEXES data dictionary views:
- Number of rows
- Number of chained rows
- Exact number of data blocks storing data
- Exact number of data blocks allocated, but never used
- Average row length, including row overhead
- Average available free space in each data block
The views listed above describe tables that have been modified since the last time table statistics were gathered on them.
They are not populated immediately, but after a time lapse (usually 3 hours).