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

From: Hemant K Chitale <hemantkchitale_at_gmail.com>
Date: Mon, 8 Apr 2013 23:52:31 +0800
Message-ID: <CAMNBsZvdjRPErzEtLX2un+6PCC+urQGaWM1-XU-EjqxW_EhKgA_at_mail.gmail.com>

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
>
>
>

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

Received on Mon Apr 08 2013 - 17:52:31 CEST