Oracle PDBs related to tablespace

Idea ID 2707076

Oracle PDBs related to tablespace

Hello,

We are currently on 2019.02 CP30 and we are running 'Oracle Topology by SQL'.

I have been trying to build a report, based on a customer demand to report the size of table space in Oracle PDB databases. I have not been able to find out if the discovery pattern retrieves that information or not. If not, my suggestion is to enhance the discovery pattern to retrieve this information.

Best regards,

Peter

4 Comments
Micro Focus Expert
Micro Focus Expert
Thank you for sharing your idea! It’s open for comments and kudos, and we’re looking forward to input from the community. Once there is enough community traction, it will be further reviewed by the product team
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor

So the idea here is to also discover the table spaces used by the PDBs and CDBs on Oracle databases. Today only the PDBs and CDBs themselves are discovered, not the underlying configuration supporting these databases.

ViauJoc Respected Contributor.
Respected Contributor.

The size of a database or schema can be calculated by summing the size of the Data Files. This value should definitely be populated in uCMDB in all cases.

Trusted Contributor.. PeterN Trusted Contributor..
Trusted Contributor..

I have Data Files with size information and i have multiple PDBs on each CDB, but currently in UCMDB there is no information available on how to relate a data file to a PDB. I know the data file size, but i don't know to which PDB the data file belong.

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.