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
Try:
SELECT owner,segment_name,segment_type
FROM dba_segments
WHERE max_extents - extents = 1;
HTH,
Brian
Luis Santos wrote:
>
> 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/
-- ======================================== Brian Peasland Raytheons Systems at USGS EROS Data Center These opinions are my own and do not necessarily reflect the opinions of my company! ========================================Received on Mon Jan 08 2001 - 09:31:31 CST
![]() |
![]() |