AWR Warehouse Queries

Submitted by dave on Tue, 04/10/2018 - 16:57

Some queries to help navigate the AWR warehouse:
Databases/Instances with info in AWR Repository

SELECT DBID, 
       DB_NAME, 
       INSTANCE_NUMBER, 
       INSTANCE_NAME, 
       HOST_NAME 
  FROM DBA_HIST_DATABASE_INSTANCE 
ORDER BY DB_NAME, INSTANCE_NUMBER;