Re: Determining when the NEXT EXTENT will happen

From: Yassir Khogaly <yassir_at_khogaly.freeserve.co.uk>
Date: Sat, 31 Oct 1998 17:50:29 -0000
Message-ID: <71filb$fmt$1@newsreader2.core.theplanet.net>

declare

        cursor cl1 is select tablespace_name,

                sum(bytes)/1000000 ||' MB' AllocatedSpace


                from dba_data_files


                group by tablespace_name


                order by tablespace_name;


        cursor cl2 is select tablespace_name,


                sum(bytes)/1000000 ||' MB' FreeSpace


                from dba_free_space


                group by tablespace_name


                order by tablespace_name;


        cursor cl3 is select tablespace_name,max_extents


                from dba_tablespaces


                order by tablespace_name;


        cursor cl4 is select tablespace_name,max(extent_id)

MaxExtentsReached

                from dba_extents


                group by tablespace_name


                order by tablespace_name;

begin

dbms_output.put_line('List of Tablespaces and Current Storage Parameters');

dbms_output.put_line('                                          ');

dbms_output.put_line('Tablespace Name ' || ' ' ||'AllocatedSpace'

                        ||'      '||'Free Space');


        FOR emprec1 IN cl1 LOOP


        FOR emprec2 IN cl2 LOOP

if emprec1.tablespace_name = emprec2.tablespace_name then

        dbms_output.put_line(emprec1.tablespace_name||

                '             '||emprec1.AllocatedSpace||


                '             '||emprec2.FreeSpace);

end if;

end loop;

END LOOP;

dbms_output.put_line('                                           ');


dbms_output.put_line('                                           ');

dbms_output.put_line('List of Tablespaces and its Allocated and Current Extents');

dbms_output.put_line('                                          ');

dbms_output.put_line('Tablespace Name '||' '||'MaxExtentsAllocated'||' '||'MaxExtentsReached');

for emprec3 in cl3 loop

for emprec4 in cl4 loop

        if emprec3.tablespace_name = emprec4.tablespace_name then

                dbms_output.put_line(emprec3.tablespace_name||


                                '                   '||emprec3.max_extents||


                                '

'||emprec4.MaxExtentsReached);

        end if;

end loop;

end loop;

end;

/

Rob wrote in message ...
>Is there someone who can tell me how to determine when an object (table or
>index) is going to throw an additional extent. ie.) how to find the
>highwatermark of the current extent, or something like that?
>
>Thanks,
>Rob.
>
>

begin 666 Yassir Khogaly.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..DMH;V=A;'D[66%S<VER#0I& M3CI987-S:7(@2VAO9V%L>0T*5$E43$4Z4V5N:6]R($]R86-L92!$0D$-"E1% M3#M(3TU%.U9/24-%.BLT-"@P*3$X,2 T-C T,#0R#0I414P[0T5,3#M63TE# M13HK-#0T,3$Y,#8W-S8-"D%$4CM(3TU%.CL[.SM+96YT.SM%;F=L86YD#0I, M04)%3#M(3TU%.T5.0T]$24Y'/5%53U1%1"U04DE.5$%"3$4Z2V5N=#TP1#TP M045N9VQA;F0-"E523#IH='1P.B\O=W=W+FMH;V=A;'DN9G)E97-E<G9E+F-O M+G5K#0I54DPZ:'1T<#HO+W=W=RYA965U+F]R9RYU:PT*14U!24P[4%)%1CM) M3E1%4DY%5#IY87-S:7) :VAO9V%L>2YF<F5E<V5R=F4N8V\N=6L-"E)%5CHQ <.3DX,3 S,50Q-S4P,CE:#0I%3D0Z5D-!4D0-"@`` `
end Received on Sat Oct 31 1998 - 11:50:29 CST