关于SHOW_SPACE()工具的用法

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

TOM写了个好 工具 SHOW_ SPACE,这个 工具对于来讲其实就是个存储过程，这个存储过程可以用来分析空间使用情况，有了此 工具，就不用再通过写SQL语句来看每条记录或表占用表空间的大小了，使用起来很方便。

具体使用过程如下：

首先需要创建一个存储过程:

d:/>sqlplus /nolog

SQL>connect/assysdba

SQL>createorreplaceprocedure SHOW_ SPACE

(p_segnameinvarchar2,

  p_owner   invarchar2defaultuser,

  p_type    invarchar2default'TABLE',

  p_partitioninvarchar2defaultNULL)

as

    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;

    procedurep(p_labelinvarchar2,p_numinnumber)

    is

    begin

        dbms_output.put_line(rpad(p_label,40,'.')||

                              p_num);

    end;

begin

   

    dbms_ SPACE.unused_ SPACE

    (segment_owner     =>p_owner,

      segment_name      =>p_segname,

      segment_type      =>p_type,

      partition_name    =>p_partition,

      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('TotalBlocks',l_total_blocks);

    p('TotalBytes',l_total_bytes); 1 <script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>