Re: Script to find segment that have just ONE more extent

   Hi!

   Not really.

   Letīs assume that you have a segment with a next extent of 500000 bytes and, on its tablespace, you have the highest chunk of freespace of 600000 and the next one of 550000.

   The next allocation can be done AND THE FOLLOWING ONE too, as both two largest free extents can fit a next allocation of 500000.

   And the highest-contiguous-in-each-tbsp is < (next_extent*2)

   Best regards

In article <978964659.25384.0.nnrp-12.c30bdde2_at_news.demon.co.uk>,   "andrew_webby at hotmail" <spam_at_no.thanks.com> wrote:
> Assuming that the scripts you talk of are going by the highest
 contiguous
> amount available in each tablespace (and seeing whose next_extent is
 more
> than that), then just search for highest-contiguous-in-each-tbsp <
> (next_extent*2).
>
> "Luis Santos" <lsantos_at_pobox.com> wrote in message
> news:93cc8o$db5$1_at_nnrp1.deja.com...
> > Hello!
> >
> > There are several scripts on the Web (and itīs easy to write
 one!)
> > that show the segments that canīt be extended anymore, due to
> > maxextents reached or no more contiguous space on the segmentīs
> > tablespace.
> >
> > But itīs not easy to find or write a script that shows all the
> > segments that can allocate more one, and only one, extent.
> >
> > Does someone has such a script?
> >
> > Best regards
> >
> > --
> > Luis Santos
> > Oracle DBA
> >
> >
> > Sent via Deja.com
> > http://www.deja.com/
>
>

--
   Luis Santos
   Oracle DBA


Sent via Deja.com
http://www.deja.com/