Re: Extent Failure

Your script is correct, though I would probably have used an inline view. Anyway, what tablespace manager does (at least in 7.3) it simply list the total amount of free space. This may be scattered in many extents. As you need a contiguous extent, you should rely on your statement. The performance pack of OEM comes with pre-defined events to 'warn' you, ie page you or e-mail you.

Hth,

--
Sybrand Bakker, Oracle DBA
rchennaa <rchennaa_at_atos-group.com> wrote in message news:7tvo9u$l6f$1_at_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 Thu Oct 14 1999 - 14:00:24 CDT