How can we check the number of records in each partition using Oracle?

10 months ago

Jackson Davis

1 minute

You can use the following SQL statement to check the number of records in each partition:

SELECT table_name,
       partition_name,
       num_rows
FROM all_tab_partitions
WHERE table_name = 'your_table_name';

In this case, your_table_name is the name of the table you want to view. This statement will show the table name, partition name, and number of data entries for each partition.