Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: sufficient next extent space
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-lReceived on Mon Feb 07 2005 - 11:05:22 CST