RelationalDBDesign RelationalDBDesign 


Partitioned Tuning   «Prev 

dba_tab_partitions view

  1. Describe the dba_tab_partitions view.
  2. 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

  1. DBA_TAB_PARTITIONS provides such information for all partitions in the database
  2. 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.