-- 统计表利用率,统计前100个
select * from (select SEGMENT_NAME,BYTES/1024/1024/1024 from user_segments where tablespace_name='SCM' order by BYTES/1024/1024/1024 desc) WHERE rownum <100;
-- 清理
TRUNCATE TABLE 【表名】
-- 统计表利用率,统计前100个
select * from (select SEGMENT_NAME,BYTES/1024/1024/1024 from user_segments where tablespace_name='SCM' order by BYTES/1024/1024/1024 desc) WHERE rownum <100;
-- 清理
TRUNCATE TABLE 【表名】
评论区