Re: EM, capacity planning and monitoring

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: s.cislaghi@xxxxxxxxx
  • Date: Tue, 14 Sep 2010 07:47:54 +0100

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@xxxxxxxxx> 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@xxxxxxxxx> wrote:
>
> Stefano,
>
> Not an ...
http://www.stefanocislaghi.eu

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2010