Oracle: DBA_TAB_PARTITIONS

This column is sometimes useful when inspecting a plan table's partition_start and partition_stop columns.

Partitioned tables

dba_tab_subpartitions

Information about partitions on object level is found in the data dictionary in dba_part_tables.