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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: sufficient next extent space

Re: sufficient next extent space

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Mon, 07 Feb 2005 10:58:04 -0500
Message-Id: <s20749ce.064@gcrta.org>


but this is a brand new datafile - why would it have to be coalesced >>> "tim" <tim_at_evdbt.com> 2/7/05 10:09:13 AM >>> alter tablespace xxx coalesce

> > My point is that IF they are ajacent they will be counted by
> > max(bytes) as one lump (extent). I.e. max(bytes) gives the largest

> > continuous lump of freespace. I think you have an error in your
> > calculations / assumptions. continuous lump of freespace = free
> > extents if they are adjacent

--
http://www.freelists.org/webpage/oracle-l 



--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 07 2005 - 11:05:22 CST

Original text of this message

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