Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Script to find segment that have just ONE more extent
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/
Received on Mon Jan 08 2001 - 08:37:24 CST