Oracle ->> 查看分区表的每个分区的数据行分布情况
时间:2021-07-01 10:21:17
帮助过:4人阅读
dbms_rowid.rowid_object(rowid) obj_id, ora_hash ( id,
31,
0) part_id ,
count(
*)
from
sales_fact_part
group by dbms_rowid.rowid_object(rowid), ora_hash(id,
31,
0)
order by 1;
Oracle ->> 查看分区表的每个分区的数据行分布情况
标签: