Documentation forDatabase Performance Analyzer

Manually group database instances in DPA

DPA automatically groups Oracle Real Application Clusters (RAC) instances and Oracle multitenant container databases (CDB) containing pluggable databases (PDB). You can manually group other database instances so that they are displayed together on the DPA home page. For example, you can create groups based on type or location. When database instances are grouped, you can view information about all instances in the group.

A database instance can be included in only one group.

To move a database instance from one group to another, remove the instance from the group it is currently in. Then add it to the other group.

See the following sections:

Create a custom group

  1. On the DPA home page above the list of database instances, click Group Settings.

    The Manage Instance Groups dialog box lists the existing groups.

  2. Click Add.

    The Add Instance Group dialog box lists the database instances that are not members of an existing group.

  3. Enter a name, select the database instances to include, and then click Add.

  4. Click OK at the confirmation message.

Modify a group

You can modify a group to change the name, add database instances, or remove database instances.

  1. On the DPA home page above the list of database instances, click Group Settings.

    The Manage Instance Groups dialog box lists the existing groups.

  2. Select the group that you want to modify, and click Modify.

    The Modify Instance Group dialog box lists the group's members (checked) as well as database instances that are not members of an existing group.

  3. To change the group name, edit the text in the Name box.

  4. To add an instance, select the instance.

  5. To remove an instance, clear the checkbox next to the instance name.

  6. Click Save.

  7. Click OK at the confirmation message.

Delete a group

If you delete a group that contains database instances, the instances are ungrouped.

  1. On the DPA home page above the list of database instances, click Group Settings.

    The Manage Instance Groups dialog box lists the existing groups.

  2. Select the group you want to delete, and click Delete.

  3. Click Yes at the confirmation message, and then click OK.

Show or hide groups on the DPA home page

Toggle the Show Groups button above the list of database instances to show or hide groups.

  • When you show groups (the default), the DPA home page lists ungrouped database instances first, followed by groups in alphabetical order. You can expand or collapse each group. Click the group name to view information about all instances in the group.

  • When you hide groups, the DPA home page lists database instances alphabetically.