Re: Finding space-bound objects?

tim.kearsley_at_milton-keynes.gov.uk (Tim Kearsley) wrote in message news:<725736ef.0204300252.2ce88692_at_posting.google.com>...
> Hi all,
>
> I've looked at several scripts which purport to produce a list of
> tables, indexes etc. which can't extend within the tablespace, because
> the largest contiguous piece of free space is less than the
> NEXT_EXTENT value for the segment.

<Snipped>

Are you sure that you really needs the script like this ? Looks like your extent sizes are much bigger than needed. Maybe you're a victim of many-extent fobia.
For example, in 3GB LMT I have all object with extent size 64kb and PCTINCR = 0. So there is no need to check if contiguous piece of free space is available, because 64kB block fits everywhere (of course if some free space is available).

If you really need a script to do this checking (stupid customer or vendor), then you can get NEXT and PCT_INCR sizes from data dictionary, combine them together and because you know number of extents already allocated, your algorithm will be pretty simple.

--
_________________________________________

Dusan Bolek, Ing.
Oracle team leader

Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.