Extent Failure

From: rchennaa <rchennaa_at_atos-group.com>
Date: Tue, 12 Oct 1999 17:30:23 +0200
Message-ID: <7tvo9u$l6f$1@pegase.production.axime.fr>

I want to detect possible next extent failures. So i use te next script

select substr(sg.tablespace_name,1,30) Tablespace,

          substr(sg.segment_name,1,30) Object,
          sg.extents extents,
          sg.next_extent next,
          max(sp.bytes) available

from dba_free_space sp, dba_segments sg where sp.tablespace_name = sg.tablespace_name having max(sp.bytes) < sg.next_extent

           group by sg.tablespace_name,
           sg.segment_name,sg.extents,sg.next_extent

order by 1,2

With this script i have the result that for example table TOTO in tablespace TBS1 can't allocate next extent

But whith Tablespace Manager of the Entreprise Manager i see that for the seem tablespace we have enough place

Could anyone explain me this ?

Cheers
rchennaa_at_atos-group.com Received on Tue Oct 12 1999 - 10:30:23 CDT