oracle sql 输出宽度,关于expdp导出数据大小概念问题请教 — oracle-tech

declare

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('NC61_BR0413',

'GL_DETAIL',

'TABLE PARTITION',

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,

'SYS_P403');

dbms_output.put_line('Unformatted Blocks = ' || v_unformatted_blocks);

dbms_output.put_line('FS1 Blocks = ' || v_fs1_blocks);

dbms_output.put_line('FS2 Blocks = ' || v_fs2_blocks);

dbms_output.put_line('FS3 Blocks = ' || v_fs3_blocks);

dbms_output.put_line('FS4 Blocks = ' || v_fs4_blocks);

dbms_output.put_line('Full Blocks = ' || v_full_blocks);

end;因为是分区表 所以贴了一个分区的信息

Unformatted Blocks = 0

FS1 Blocks = 2

FS2 Blocks = 0

FS3 Blocks = 0

FS4 Blocks = 42

Full Blocks = 33513