The output of the desc dba_tab_partitions query is listed above.For purposes of this simulation, the num_rows, chain_count and avg_row_len values are highlighted in yellow. These indicate when to reorganize the partition.
DBA_TAB_PARTITIONS displays partition-level partitioning information, partition storage parameters, and partition statistics determined by
ANALYZE statements for all partitions in the database. Its columns are the same as those in "ALL_TAB_PARTITIONS".
DBA_TAB_PARTITIONS
DBA_TAB_PARTITIONS provides the partition-level partitioning information, partition storage parameters, and partition statistics determined by ANALYZE statements for all partitions in the database.
Its columns are the same as those in "ALL_TAB_PARTITIONS"
ALL_TAB_PARTITIONS
ALL_TAB_PARTITIONS provides partition-level partitioning information, partition storage parameters, and partition statistics collected by ANALYZE statements for partitions accessible to the current user.
Related Views
DBA_TAB_PARTITIONS provides such information for all partitions in the database
USER_TAB_PARTITIONS provides such information for partitions of all partitioned objects owned by the current user.
This view does not display the OWNER column
USER_TAB_PARTITIONS provides such information for partitions of all partitioned objects owned by the current user.
This view does not display the OWNER column.