Hi I seem to be getting this behaviour because some the sizes I specified were not a multiple of the extent size. Regards Pete On 8 April 2013 16:52, Hemant K Chitale <hemantkchitale@xxxxxxxxx> wrote: > 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 >> >> >> -- Regards Pete -- //www.freelists.org/webpage/oracle-l