Re: purging recycle bin
Date: Thu, 23 Apr 2015 06:44:17 -0700 (PDT)
Message-ID: <8327365d-61e9-4560-b77f-25a06d58bffd_at_googlegroups.com>
On Thursday, April 23, 2015 at 3:34:05 AM UTC-4, chris..._at_coveainsurance.co.uk wrote:
> I am working on Oracle Database 12c Enterprise Edition Release 12.1.0.1.0
> on windows 2012 server
>
> Have just purged recyclebin with 200g of data
> / all objects were under a schema owner that had default schema CLMDATA
>
>
> Have checked asm disk group clmdata
>
> free space
> CLMDATA 512 4096 1048576 CONNECTED EXTERN 1535985 104318
>
>
> It stayed the same , I was hoping to see it increase by approx. 200g
>
>
> Can I expect a long period before my free space reduces as objects within the disk group increase as they should theoretically have 200g to play with or am I getting this wrong?
>
> thanks in advance
> Chris B
>
> PS I have stopped the original cause of objects going into the recyclebin for future issues
Chris, why would you expect changing re-usable space which still contains deleted objects for potential recovery and which is visible via the recyclebin to just being free space would have any effect on the ASM diskgroup allocation?
The ASM diskgroup is basically allocated file space that is available. Once the database takes a chunk of the diskgroup ASM does not know or care what the database does with it.
HTH -- Mark D Powell -- Received on Thu Apr 23 2015 - 15:44:17 CEST