用于分析table的内存使用情况space_usage

set serveroutput on size 10000;
declare
v_tabname varchar2(30) :='&1';
v_unformatted_blocks number;
v_unformatted_bytes number;
v_fs1_blocks number;
v_fs1_bytes number;
v_fs2_blocks number;
v_fs2_bytes number;
v_fs3_blocks number;
v_fs3_bytes number;
v_fs4_blocks number;
v_fs4_bytes number;
v_full_blocks number;
v_full_bytes number;
begin
dbms_space.space_usage (
segment_owner =>'BJWSKP',
segment_name   =>v_tabname,
segment_type    =>'TABLE',
v_unformatted_blocks =>v_unformatted_blocks,
v_unformatted_bytes =>v_unformatted_bytes,
v_fs1_blocks =>v_fs1_blocks,
v_fs1_bytes =>v_fs1_bytes,
v_fs2_blocks =>v_fs2_blocks,
v_fs2_bytes =>v_fs2_bytes,
v_fs3_blocks =>v_fs3_blocks,
v_fs3_bytes =>v_fs3_bytes,
v_fs4_blocks =>v_fs4_blocks,
v_fs4_bytes =>v_fs4_bytes,
v_full_blocks =>v_full_blocks,
v_full_bytes =>v_full_bytes);
dbms_output.put_line('Unformatted Blocks = '||v_unformatted_blocks);
dbms_output.put_line('FS1 0-25% Blocks = '||v_fs1_blocks||' Bytes = '||v_fs1_bytes);
dbms_output.put_line('FS2 25-50% Blocks = '||v_fs2_blocks||' Bytes = '||v_fs2_bytes);
dbms_output.put_line('FS3 50-75% Blocks = '||v_fs3_blocks||' Bytes = '||v_fs3_bytes);
dbms_output.put_line('FS4 75-100% Blocks = '||v_fs4_blocks||' Bytes = '||v_fs4_bytes);
dbms_output.put_line('Full Blocks = '||v_full_blocks||' Bytes = '||v_full_bytes);
end;
/