1-- Partitions of a table
2SELECT TABLE_OWNER, TABLE_NAME, PARTITION_NAME, SUBPARTITION_COUNT,
3 HIGH_VALUE, PCT_USED, NUM_ROWS, LAST_ANALYZED
4FROM DBA_TAB_PARTITIONS
5WHERE TABLE_OWNER = 'MY_OWNER'
6 AND TABLE_NAME = 'MY_TABLE';
7-- Subpartitions of a table
8SELECT TABLE_OWNER, TABLE_NAME, PARTITION_NAME, SUBPARTITION_NAME,
9 HIGH_VALUE, PCT_USED, NUM_ROWS, LAST_ANALYZED
10FROM DBA_TAB_SUBPARTITIONS
11WHERE TABLE_OWNER = 'MY_OWNER'
12 AND TABLE_NAME = 'MY_TABLE';