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

From: Franck Pachot <franck@xxxxxxxxxx>
To: post.ethan@xxxxxxxxx
Date: Sun, 16 Feb 2020 22:52:07 +0100

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@xxxxxxxxx> 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@xxxxxxxxx> 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]

References:
- How do I get this number down (storage used) - ATP
  - From: Ethan Post
- Re: How do I get this number down (storage used) - ATP
  - From: Ethan Post

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

Other related posts: