Summary: need to create a db which stores almost all the information about all of our databases; licenses: when to renew, patches, Grid/Oralce home, core db related stuff: growth pattern and almost everything.
Looking for some expert thoughts/suggestions & advices, how to go about.
What we are thinking, as we already have implemented OEM 12c, planning to extract data and all info from OEM 12c and place it into a separate schema, within the same OEM 12c db.
Would like to develop a Warehouse for our own databases, trends & pattern.
OEM 12c, would like to configure a database inventory schema, extract all relevant information from OEM 12c and save into this db inventory schema; os + db + tablespaces + data files, growth, new users/schemas creation, top segments + + +
Basically an effort to gather all the info about our dbs and their licenses, performances/metrics + history too, plus growth pattern.
Please advise/guide, what should be the best possible way to achieve this, if anyone has worked on anything like this, that'll be great.
Thanks in advance, do share your input, thoughts, suggestions, advises or even queries too, if requires more information.