对象的空间分配与空间利用情况代码,PLSQL代码库,德仔网

代码语言

代码分类

【PLSQL】对象的空间分配与空间利用情况

作者:Dezai.CN / 发布于2013/5/28/ 860


	CREATE OR REPLACE PROCEDURE show_space (p_segname in varchar2, p_type in varchar2 default 'TABLE' , p_owner in varchar2 default user) AS v_segname varchar2(100); v_type varchar2(10); l_free_blks number; l_total_blocks number; l_total_bytes number; l_unused_blocks number; l_unused_bytes number; l_LastUsedExtFileId number; l_LastUsedExtBlockId number; l_LAST_USED_BLOCK number; PROCEDURE p( p_label in varchar2, p_num in number ) IS BEGIN dbms_output.put_line( rpad(p_label,40,'.')|| p_num ); END; BEGIN v_segname := upper(p_segname); v_type := p_type; if (p_type = 'i' or p_type = 'I') then v_type := 'INDEX'; end if; if (p_type = 't' or p_type = 'T') then v_type := 'TABLE'; end if; if (p_type = 'c' or p_type = 'C') then v_type := 'CLUSTER'; end if; --以下部分不能用于ASSM dbms_space.free_blocks ( segment_owner => p_owner, segment_name => v_segname, segment_type => v_type, freelist_group_id => 0, free_blks => l_free_blks ); --以上部分不能用于ASSM dbms_space.unused_space ( segment_owner => p_owner, segment_name => v_segname, segment_type => v_type, total_blocks => l_total_blocks, total_bytes => l_total_bytes, unused_blocks => l_unused_blocks, unused_bytes => l_unused_bytes, LAST_USED_EXTENT_FILE_ID => l_LastUsedExtFileId, LAST_USED_EXTENT_BLOCK_ID => l_LastUsedExtBlockId, LAST_USED_BLOCK => l_LAST_USED_BLOCK ); --显示结果 p( 'Free Blocks', l_free_blks ); p( 'Total Blocks', l_total_blocks ); p( 'Total Bytes', l_total_bytes ); p( 'Unused Blocks', l_unused_blocks ); p( 'Unused Bytes', l_unused_bytes ); p( 'Last Used Ext FileId', l_LastUsedExtFileId ); p( 'Last Used Ext BlockId', l_LastUsedExtBlockId ); p( 'Last Used Block', l_LAST_USED_BLOCK ); END;

	执行结果将如下所示

	 SQL> set serveroutput on; SQL> exec show_space('test'); Free Blocks.............................1 Total Blocks............................8 Total Bytes.............................65536 Unused Blocks...........................6 Unused Bytes............................49152 Last Used Ext FileId....................1 Last Used Ext BlockId...................48521 Last Used Block.........................2 PL/SQL procedure successfully completed

试试其它关键字

　空间利用　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)