What is the best way to query all databases in a company?
In working through a SR, a couple specific queries were offered by support to help analyze databases that might be at risk. The customer would like to run the query against every database in the environment without having to do it manually. Is there a suggested best practice, re-usable script, etc. for doing this?
You can refer the following doc to create your custom queries.
For 12c refer to below OTN doc
Oracle® Enterprise Manager Cloud Control Administrator's Guide
12c Release 3 (184.108.40.206)
Using Metric Extensions
9.4.4 SQL Adapter
Executes custom SQL queries or function calls supported against single instance databases and instances on Real Application Clusters (RAC).