不是一个分区一个分区查,是要group by 分组查出来,结果类似 partiton_name,rowcount par1,11122 par2,3333
select count(1),partition_name from table_name partition(select PARTITION_NAME from all_tab_partitions where table_owner='CADS'and table_name='table_name) group by partition_name
select t.partition_name,t.num_rows from all_tab_partitions t where table_name='table_name'
partiton_name,rowcount
par1,11122
par2,3333
select t.partition_name,t.num_rows from all_tab_partitions t where table_name='table_name'
有可能不准确,如果想要查看实时的各分区的数据量,我只能想到使用plsql的动态sql实现了。
测试可用,更新统计数据后应该相对准确.