Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Script to find segment that have just ONE more extent

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

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Mon, 8 Jan 2001 15:31:31 GMT
Message-ID: <3A59DD53.62FD9E62@edcmail.cr.usgs.gov>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US