Re: Amount of space used by a segment changes when datafile size changed in ASSM tablespace

From: Peter Hitchman <pjhoraclel_at_gmail.com>
Date: Wed, 10 Apr 2013 16:45:43 +0100
Message-ID: <CAPMSPxPOn3yoqXWQ5BQDNnHuNFBJU7hpQkVUqhKQyW63th3nuA_at_mail.gmail.com>

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_at_gmail.com> 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_at_gmail.com> 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
>>
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>

-- 
Regards

Pete


--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 10 2013 - 17:45:43 CEST