With LMT and uniform sizes, you will probably need to decide on some number
of bytes free at which you holler. An example the covers DMT and LMT is
below; the threshold is 30 meg.
declare
v_count number := 0;
begin
dbms_output.enable(200000);
select /*+RULE*/ count(tablespace_name) into v_count from
dba_segments outer
where greatest(nvl(next_extent,0),30000000) > (select
nvl(max(bytes),0) from dba_free_space where tablespace_name =
outer.tablespace_name)
and segment_type not in ('ROLLBACK','TEMPORARY');
if v_count > 0 then
dbms_output.put_line('BLOWOUT IMMINENT');
end if;
end;
/
----------------------------------------------------------------
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at
http://www.freelists.org/archives/oracle-l/
FAQ is at
http://www.freelists.org/help/fom-serve/cache/1.html
Received on Mon Jun 21 2004 - 15:39:27 CDT
