Looks like an OEM bug. Oracle doesn't change the size of a pre-existing extent. Sent from my android phone. On Apr 8, 2013 11:32 PM, "Peter Hitchman" <pjhoraclel@xxxxxxxxx> wrote: > Oracle Enterprise Edition 11.1.0.7.5 > Linux 64 bit RHL 4.5 > > I have a question about space allocation in ASSM tablespaces. > > I am using a 8KB block size and 8MB extents. > > I started off with a single extent segment reported as using 9MB according > to OEM, I checked dba_data_files and dba_free_space_coalesced and the sum > of bytes used minus the total free bytes used agreed this figure. > > When I increased the file size from 33MB to 40MB, the amount of space used > is reported as 16MB. > When I shrink the file to 33MB, the amount of space used goes back down to > 9MB. > When I shrink the file to 32MB the amount of space used goes up to 16MB. > > I feel I should understand this, but it is escaping me. > > Regards > > Pete > > > -- > //www.freelists.org/webpage/oracle-l > > > -- //www.freelists.org/webpage/oracle-l