查询表存在大量行迁移
新建chained_rows
sqlplus / as sysdba
@?/rdbms/admin/utlchain.sql
@?/rdbms/admin/utlchain.sql
对所需要查询的表做分析:
analyze table lf.t list chained rows into chained_rows;
查询分析后的情况
select count(*) from chained_rows where table_name='T';
生成批量分析表的脚本:
select 'analyze table '||owner||'.'||table_name||'list chained rows into chained_rows;' from user_tables;
select * from chained_rows;
创建表脚本:
create table CHAINED_ROWS (
owner_name varchar2(30),
table_name varchar2(30),
cluster_name varchar2(30),
partition_name varchar2(30),
subpartition_name varchar2(30),
head_rowid rowid,
analyze_timestamp date
);
owner_name varchar2(30),
table_name varchar2(30),
cluster_name varchar2(30),
partition_name varchar2(30),
subpartition_name varchar2(30),
head_rowid rowid,
analyze_timestamp date
);
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24996904/viewspace-774116/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24996904/viewspace-774116/