That's the problem the new datafile is showing as multiple free extents so max won't work. >>> <Tony.Adolph@xxxxxx> 2/7/05 9:20:05 AM >>> Hi Jeffrey, 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 I don't know why your new datafile isn't showing up as 99% free, i.e. max(bytes) = 99% of total size of new datafile, but that's a different problem.... Tony "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx> 02/07/2005 02:36 PM To <Tony.Adolph@xxxxxx> cc Subject Re: sufficient next extent space That is what I currently do. That won't combine if adjacent. Only want to combine the free extents if they are adjacent to each other. >>> <Tony.Adolph@xxxxxx> 2/7/05 8:36:31 AM >>> Hi Jeff, Run this query. I have grouped by file_id instead of TS: select file_id, sum(bytes) free, max(bytes) max_extent from dba_free_space group by file_id I think you will see that do not have 3 (or how ever many) large contiguous extents... max(bytes) gets the largest for you.... If it doesn't come up in the column, then the big extents you extpected is already split somehow. Tony "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx> 02/07/2005 02:19 PM To <Tony.Adolph@xxxxxx> cc Subject Re: sufficient next extent space (select tablespace_name, sum(bytes) free, max(bytes) max_extent from dba_free_space group by tablespace_name) fs But this is grouping solely by tablespace_name getting max(bytes). In my example: 427 9 507,904 ***FREE*** 427 63,497 507,904 ***FREE*** 427 126,985 507,904 ***FREE*** 427 190,473 421,824 ***FREE*** I would want all 3 free space entries combined since they are adjacent. This is a brand new datafile and notice all Oracle setup the free extents. >>> <Tony.Adolph@xxxxxx> 2/7/05 8:17:17 AM >>> The adjacent extents are already summed... look at column max_extent in dba_free_space Tony "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx> Sent by: oracle-l-bounce@xxxxxxxxxxxxx 02/07/2005 02:07 PM Please respond to JBECKSTROM@xxxxxxxxx To <Tony.Adolph@xxxxxx> cc <oracle-l@xxxxxxxxxxxxx>, <oracle-l-bounce@xxxxxxxxxxxxx>, <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>, <ORACLE-L@xxxxxxxxxxxxx>, <oracledba@xxxxxxxxxxx>, <oracle-rdbms@xxxxxxxxxxxxxxx> Subject Re: sufficient next extent space -- //www.freelists.org/webpage/oracle-l