AWR Warehouse Queries

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;