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

Hi Ethan,
Yes, it is basically all files except SAMPLESCHEMA. Your TEMP tablespace number looks unreal here. Is there a problem in the query? You get the exact value for the used/max displayed from V$PDB (this is what tracks multitenant quotas on pluggable databases): (select max_size/1024/1024/1024 from v$pdbs) (select total_size/1024/1024/1024 from v$pdbs) And this should be near the sum of:
(select sum(bytes)/1024/1024/1024 from v$datafile where plugged_readonly='NO')
(select sum(bytes)/1024/1024/1024 from v$tempfile) The SAMPLESCHEMA is a read-only transported tablespace that doesn't count here (probable the same files shared by all PDBs) Regards,
Franck.

On Thu, Feb 13, 2020 at 3:58 PM Ethan Post <post.ethan_at_gmail.com> wrote:

> 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