Skip to Main Content
  • Questions
  • OEM Repository Views - Database size

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Terri.

Asked: June 23, 2020 - 7:01 pm UTC

Answered by: Connor McDonald - Last updated: June 29, 2020 - 5:55 am UTC

Category: SQL Plus - Version: 12.2

Viewed 100+ times

You Asked

I've been tasked with querying OEM repository for the size of each database, which seems to be a bit difficult to find. I've tried sysman.MGMT$DB_TABLESPACES for used_size but get negative numbers returned.

Could you please assist?
Thank you!

and we said...

Check out sysman.mgmt$metric_current

for the labels

'Tablespace Allocated Space (MB)'
'Tablespace Used Space (MB)'
'Tablespace Free Space (MB)'

and you rated our response

  (1 rating)

Reviews

Thank you!

June 27, 2020 - 3:24 am UTC

Reviewer: Terri from Lansing MI

Thank you for answering my question! There are so many mgmt tables, this helped.
Connor McDonald

Followup  

June 29, 2020 - 5:55 am UTC

Glad we could help

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database