Re: How do I get this number down (storage used) - ATP

SQL Developer view of things here. If you add up allocated for items 1-6 you end up near the 15GB I am using of my 20. item 7 is 200GB and 8 is too big for me to think about. Guessing that is shared :)

Maybe this is how it is being calculated? Maybe not. Are backups included in total storage?

[image: image.png]

On Thu, Feb 13, 2020 at 8:38 AM Ethan Post <post.ethan_at_gmail.com> wrote:

> Anyone know how to see what is using the 76% here. My guess is mostly
> extended but half empty datafiles. From a UI point of view if I run use up
> to 99% and then drop everything and it stays at 99% but empty space, this
> is going to be confusing for the new Oracle ATP users.
>
> I have purged recycle bin and dropped any large objects.
>
> I am familiar with the old techniques to recover actual unused storage but
> looking for ATP specific answers here. Not sure I want to try go through
> hassle of some of those things, this is autonomous right :)
>
> For anyone from Oracle watching in cloud group here, I could see less
> experienced users really wanting some good reporting and ability to get
> this number down. Ideally being able to click this particular graphic and
> get a lot more. Maybe exists?? I am new to ATP.
>
> Thanks,
> Ethan
>
> [image: image.png]
>

--
http://www.freelists.org/webpage/oracle-l





image/png attachment: image.png



image/png attachment: image.png