Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Querying Tablespace sizes for multiple databases in OEM

945183Jun 21 2012 — edited Jun 22 2012

Hi,

I'm new to the role and I've been tasked with ensuring that all tablespaces across all databases are below a certain threshold i.e 85% of their size. Now we have a lot of databases (thousands) so to run a query on each database isn't really an option. Is there a way for me to query the OEM repository to give me the Tablespace Size, Tablespace Used and Percentage Used for all databases? I've been poking around in OEM and it's only letting me get the info for a single DB at a time. I've spent hours Googling this but haven't really come across anything definitive so that I can make a start. Any help in pointing me in the right direction would be really appreciated.

Cheers

Ryan

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 20 2012

Added on Jun 21 2012

2 comments

2,780 views