To restrict Capacity Planning (databases or hosts) and Oracle SQL Warehouse insight/analysis to a subset of enabled databases/hosts, use the Database Name/Host or Host filter.

1. Click Select to display the Select by Names/Hosts dialog.
2. Choose how you want to filter depending on database or host.
   • For databases filter by:
     • Database name
     • Database host name (all databases that have at least one instance under the chosen host name)
     • Container database name (all PDBs within the chosen CDB)
     • VM cluster name
     • Exadata system name
   • For hosts filter by:
     • Host name
     • VM cluster name
     • Exadata system name
3. Depending on the option you chose in step 2, select a database or host from the drop-down list. Repeat this step until you've added all databases/hosts of interest.
4. Click Apply.

To remove the filter, click Clear.