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