-- 查询表的碎片情况SELECT table_name,round((blocks*8),2)as"Size (KB)",round((num_rows*(avg_row_len/1024),2))as"Actual Data (KB)"FROM user_tables
WHERE table_name ='YOUR_TABLE_NAME_IN_UPPERCASE';-- 查询表的碎片情况的扩展信息SELECT table_name,round((blocks*8),2)as"Size (KB)",round((num_rows*(avg_row_len/1024),2))as"Actual Data (KB)",round((blocks*8)-(num_rows*(avg_row_len/1024)),2)as"Wasted Space (KB)"FROM user_tables
WHERE table_name ='YOUR_TABLE_NAME_IN_UPPERCASE';
评论已关闭