Tools and Utilities - Expert Oracle RAC Performance Diagnostics and Tuning - page 144

Console

>EMCLI
>EMCLI

RMAN Catalog

EMCLI

BI Publisher

OMS1

JDBC

Repository

Targets

OMS2

Load
Balancer

Firewall

OMS3

JDBC

Repository

Agent

OMS4

Plug-ins

Oracle MOS

Figure 6-1. Three-tier architecture

Performance Manager
Apart from the database administration and maintenance functionality, the Database Express also contains the
performance manager. This feature requires the Oracle Tuning Pack to be installed.
Figure 6-2 shows a Database Express 12c Summary health chart of the cluster and shows RAC-specific charts,
overall workload, top SQL, etc. By highlighting specific items on the right side of each chart, additional details related
to the specific highlighted item can be obtained by drilling down into them. For example, on the activity sessions chart
for additional information on high CPU users, highlight the CPU tag and drill down to get additional information.