Manage System Query Groups

You can organize system queries into groups based on a role or topic of interest. For example, you can create groups for GSS Support and Tech Services as well as for Oracle tablespace use, Oracle rollback contention, and Oracle redo contention. Organizing queries into groups allows you to streamline query execution by running all queries in a group at the same time.

To manage system query groups:

1. In System Management Center, click Diagnostics in the left navigation and click Groups.
   You see a list of all the available system query groups.

   Open

   

2. To create a new group, right click any row in the workspace and select New.

   Open

   

3. In the Group dialog box, complete the appropriate fields and click Next.

4. In the Queries dialog box, complete the appropriate fields and click Save & Close.
   You see the new group in the Groups workspace.

5. To edit a group, right click the group and select Edit.

6. Complete the appropriate fields in the Group and Queries dialog boxes and click Save & Close.

7. To create a copy of the existing group, right click the group, select Clone Query, enter a new group name, and click OK.

8. To delete a group, right click the group, select Delete, and click OK in the Delete items dialog box.