Re: EM, capacity planning and monitoring
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 14 Sep 2010 07:47:54 +0100
Message-ID: <AANLkTik5mxAyoOkv-xtQaM8tPVJB=QKreD4gFWMDLraa_at_mail.gmail.com>
You don't mention what version, or storage allocation scheme you are using. It sounds a wee bit suspicious, recycle bin extents are free space, so they can be, and usually are, reallocated when more space is required. I could *imagine* a scenario where you effectively have fragmented free space though because none of the recycle bin objects have extents of the right size.
Date: Tue, 14 Sep 2010 07:47:54 +0100
Message-ID: <AANLkTik5mxAyoOkv-xtQaM8tPVJB=QKreD4gFWMDLraa_at_mail.gmail.com>
You don't mention what version, or storage allocation scheme you are using. It sounds a wee bit suspicious, recycle bin extents are free space, so they can be, and usually are, reallocated when more space is required. I could *imagine* a scenario where you effectively have fragmented free space though because none of the recycle bin objects have extents of the right size.
On 14 Sep 2010 06:49, "Stefano Cislaghi" <s.cislaghi_at_gmail.com> wrote:
Quite sure.... recyclebin was about 25gb, with thousands object. Statement
purge recyclebin
has taken about 8 hours to complete...
Maybe was so big that database got problems in deleting objects... there're
no other reason for me....
ste
On 13 September 2010 22:55, D'Hooge Freek <Freek.DHooge_at_uptime.be> wrote:
>
> Stefano,
>
> Not an ...
http://www.stefanocislaghi.eu
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 14 2010 - 01:47:54 CDT