Re: Need Script

From: <Winnie_Liu_at_infonet.com>
Date: Thu, 1 Jun 2000 13:40:55 -0700
Message-Id: <10515.107472@fatcity.com>

Look at the DBMS_SPACE packages.

something like:

declare

 v_total_blocks number;
 v_total_bytes number;
 v_unused_blocks number;
 v_unused_bytes number;
 v_last_used_extent_file_id number;
 v_last_used_extent_block_id number;
 v_last_used_block number;
 v_used_bytes number;

 begin
 dbms_space.unused_space
(UPPER('&OWNER'),UPPER('&OBJECT_NAME'),UPPER('&OBJECT_TYPE'),v_total_blocks
,
 v_total_bytes, v_unused_blocks, v_unused_bytes,  v_last_used_extent_file_id, v_last_used_extent_block_id, v_last_used_block);

 v_used_bytes:=v_total_bytes-v_unused_bytes;
 dbms_output.put_line('total block='||v_total_blocks);
 dbms_output.put_line('total bytes='||v_total_bytes);
 dbms_output.put_line('total unused blocks='||v_unused_blocks);
 dbms_output.put_line('total unused bytes='||v_unused_bytes);
 dbms_output.put_line('total used bytes='||v_used_bytes);
 dbms_output.put_line('last used extent file

id='||v_last_used_extent_file_id);
 dbms_output.put_line('last used extent block id='||v_last_used_extent_block_id);
 dbms_output.put_line('tb = '||v_total_bytes);  end;
/

Winnie

"Janusz, Kenneth" <Kenneth.Janusz_at_fingerhut.com> on 06/01/2000 01:30:21 PM

To:   "'oracle-l_at_fatcity.com'" <oracle-l_at_fatcity.com>,
      "'oracledba_at_quickdoc.co.uk'" <oracledba_at_quickdoc.co.uk>,
      "'oraclenet-dba_at_lists.kisnet.com'" <oraclenet-dba_at_lists.kisnet.com>

cc: (bcc: Winnie Liu/HQ/ISC)

Subject: Need Script

Does anyone have a sql script that measures the current size of indexes?

TIA, Ken

---

Kenneth C. Janusz, CPIM       FINGERHUT DTC
Senior Technical Analyst                 6150 Trenton Lane North,
DC4N
                                     Plymouth, Minnesota

55442
 *Voice: 763.519.4403
 *Email: kenneth.janusz_at_fingerhut.com

                  |\      _,,,---,,_
            ZZZzz /,`.-'`'    -.  ;-;;,_
_________________|,4-  ) )-,_. ,\ (____-'_________________________
                '---''(_/--'  `-'\_)

"Dogs come when they're called; cats take a message and get back to you later." -- Mary Bly

---

---

If you're bored, then visit the list's website: http://www.lazydba.com
(updated daily)

to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk Received on Thu Jun 01 2000 - 15:40:55 CDT