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> create table t1(a char(1000)) storage( freelists 3);
表已创建。
sql> set serveroutput on;
sql> exec show_space('t1');
free blocks.............................0 <==number of blocks on freelist
total blocks............................5 <==total data blocks in segment
total bytes.............................20480 <==total bytes in segment
unused blocks...........................4 <==total unused blocks in segment
unused bytes............................16384 <==total unused bytes in segment
