How do I get this number down (storage used) - ATP
From: Ethan Post <post.ethan_at_gmail.com>
Date: Thu, 13 Feb 2020 08:38:55 -0600
Message-ID: <CAMNhnU3xmPpOiPOHndo0i1o1AsfTghjQPA3xn0_pnXn=auoXog_at_mail.gmail.com>
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.
Date: Thu, 13 Feb 2020 08:38:55 -0600
Message-ID: <CAMNhnU3xmPpOiPOHndo0i1o1AsfTghjQPA3xn0_pnXn=auoXog_at_mail.gmail.com>
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-lReceived on Thu Feb 13 2020 - 15:38:55 CET
- image/png attachment: image.png