---收集用户表信息
begin
dbms_utility.analyze_schema('AIRPORTRISK','COMPUTE');
end;
--查看用户表信息
select t.table_name,t.num_rows,t.blocks,t.empty_blocks
from user_tables t;
--查看总数据量
select count(blocks) * 8 /1024 SUM_M from user_tables ;
begin
dbms_utility.analyze_schema('AIRPORTRISK','COMPUTE');
end;
--查看用户表信息
select t.table_name,t.num_rows,t.blocks,t.empty_blocks
from user_tables t;
--查看总数据量
select count(blocks) * 8 /1024 SUM_M from user_tables ;