create or replace procedure show_space(v_segment_name in varchar2,
v_segment_owner in varchar2 default user,
v_segment_type in varchar2 default 'TABLE',
p_analyzed in varchar2 default 'Y',
p_partition_name in varchar2 default null) as
p_segment_name varchar2(30);
p_segment_owner varchar2(30);
p_segment_type varchar2(30);
p_space varchar2(30);
l_unformatted_blocks number;
l_unformatted_bytes number;
l_fs1_blocks number;
l_fs1_bytes number;
l_fs2_blocks number;
l_fs2_bytes number;
l_fs3_blocks number;
l_fs3_bytes number;
l_fs4_blocks number;
l_fs4_bytes number;
l_full_blocks number;
l_full_bytes number;
清理CLOB
最新推荐文章于 2023-11-24 12:19:21 发布