Re: EM, capacity planning and monitoring

  • From: Stefano Cislaghi <s.cislaghi@xxxxxxxxx>
  • To: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • Date: Tue, 14 Sep 2010 08:50:23 +0200

Correct...sorry

10.2.0.3 under solaris 10 using normal filesystem....
This db is not under my manage but I think effectly that there're few
problems... BTW EM does not calculate space used by recyclebin and does not
take care of historical datafile occupation ...

Stefano

On 14 September 2010 08:47, Niall Litchfield <niall.litchfield@xxxxxxxxx>wrote:

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


-- 
http://www.stefanocislaghi.eu

Other related posts:

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