purging recycle bin
From: <chris.brown_at_coveainsurance.co.uk>
Date: Thu, 23 Apr 2015 00:34:00 -0700 (PDT)
Message-ID: <0dffed73-8955-4031-8b79-890a546be3ff_at_googlegroups.com>
I am working on Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 on windows 2012 server
Date: Thu, 23 Apr 2015 00:34:00 -0700 (PDT)
Message-ID: <0dffed73-8955-4031-8b79-890a546be3ff_at_googlegroups.com>
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 Received on Thu Apr 23 2015 - 09:34:00 CEST