oracle对象空间产看dbsm_space

Oracle提供了dbms_space工具包，察看对象空间占用情况。以下作为备忘。

set serverout on
declare
v_user varchar2(30) := upper('&username');
v_table varchar2(40) := upper('&object_name');
v_type varchar2(10) := upper('&object_type');
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 (v_user, v_table, v_type, v_unformatted_blocks,
v_unformatted_bytes, v_fs1_blocks, v_fs1_bytes, v_fs2_blocks, v_fs2_bytes,
v_fs3_blocks, v_fs3_bytes, v_fs4_blocks, v_fs4_bytes, v_full_blocks, v_full_bytes);
dbms_output.put_line('-----------------------------------');
dbms_output.put_line('Unformatted Blocks = '||v_unformatted_blocks);
dbms_output.put_line('FS1  0% - 25% Free Blocks = '||v_fs1_blocks);
dbms_output.put_line('FS2 25% - 50% Free Blocks = '||v_fs2_blocks);
dbms_output.put_line('FS3 50% - 75% Free Blocks = '||v_fs3_blocks);
dbms_output.put_line('FS4 75% -100% Free Blocks = '||v_fs4_blocks);
dbms_output.put_line('Full Blocks = '||v_full_blocks);
end;
/