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 450000.

  The next allocation can be done BUT THE FOLLOWING ONE NOT.

  This is true in despite of any value for maxextents.

In article <3A59DD53.62FD9E62_at_edcmail.cr.usgs.gov>,   Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote:
> 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!
> ========================================
>

--
   Luis Santos
   Oracle DBA


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