Re: How do I find out free space in extent?

I have been looking at this same package. Does this give you the unused blocks above and below the high water mark?

TIA
Eric Peterson, DBA
Maurices Inc.
eric_petNOerson_at_mauriSPAMMERSces.inrg.com

In article <38613c51.3217258_at_172.16.7.5>,   violin.hsiao_at_mail.pouchen.com.tw (Violin) wrote:
> On Tue, 21 Dec 1999 11:37:40 -0000, "Andrew Williamson" <andrewweb_at_my-
deja.com>
> wrote:
>
> Or like this :
>
> set serveroutput on
> declare
> tot_block number;
> tot_byte number;
> unuse_block number;
> unuse_byte number;
> last_ext_file_id number;
> last_ext_blok_id number;
> last_block number;
> begin
>
> dbms_space.unused_space

('SCOTT','EMP','TABLE',tot_block,tot_byte,unuse_block,unuse_byte,last_ex t_file_id,last_ext_blok_id,last_block);
> dbms_output.put_line(to_char(tot_block));
> dbms_output.put_line(to_char(tot_byte));
> dbms_output.put_line(to_char(unuse_block));
> dbms_output.put_line(to_char(unuse_byte));
> dbms_output.put_line(to_char(last_ext_file_id));
> dbms_output.put_line(to_char(last_ext_blok_id));
> dbms_output.put_line(to_char(last_block));
> end;
> /
>
> >Can anyone tell me how to find out how much of my extent is actually
used?
> >ie, if I make a 50mb initial extent for a table and insert one 1mb
record,
> >what dictionary table will tell me I am using 1mb of that extent
with 49mb
> >free? Or do I need to do something weird with rowids?
> >
> >This is all going into an automated tablespace report generator
which I'll
> >post when it's finished along with an HTML historical growth
monitor. Thanks
> >in advance for any help.
> >
> >Andrew
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 22 1999 - 13:41:47 CST