Re: free space in table

This is exactly what I was looking for. Thanks! I have one more question on this subject, is it possible to get the high water mark on each table?

"Jason" <j_at_j.com> wrote in message news:01bfb865$a7d931a0$92da13ac_at_jason...
> I use the following scripts which gives me enough warning to make some
> changes before it too late, without having to wade through a huge list of
> tables.
>
> select owner, bytes, extents, max_extents, segment_name
> from dba_segments
> where extents >= trunc(max_extents * 0.9)
>
>
> select extents, max_extents, initial_extent, next_extent, bytes,
> segment_name
> from dba_segments s
> where (next_extent * 1.5) >
> (select max(bytes)
> from dba_free_space f
> where f.tablespace_name = s.tablespace_name)
>
> Regards
> Jason
>
>
> john flanagan <pti_at_iol.ie> wrote in article
> <WgxQ4.7860$xA.19972_at_news.iol.ie>...
> > Is there a function in PL/SQL to check the space available in a table.
 I
> > can check data files and table spaces using the storage manager but I
 can't
> > find a way to see if tables are reaching their max extents
> >
> >
> >
Received on Mon May 08 2000 - 00:00:00 CDT