Database Reference
In-Depth Information
As you can see the summary screen is divided into a number of areas. In this example the time picker has been
hidden to free up some more space. When shown it allows you to select an interval over the last hour or alternatively
use a historic time period if it is still available. It then presents the options to enter different other views of your
system, namely:
•
RAC if applicable
•
(Top) Activity
•
Workload
•
Monitored SQL
•
ADDM
•
Current ADDM findings
We will cover the most interesting ones of these a little later. Continuing the discussion of the summary screen
you can see the following panes:
•
Host runnable processes
, indicating the load on the server. The contributors of the load are
broken down into background and foreground processes plus all the other non-Oracle
processes contributing to the current state of the operating system's run queue.
•
Host memory:
shows the database's SGA and its components relative to the total memory on
the system. This is a useful view to show automatic memory operations of individual SGA
components.
•
Active Sessions:
this panel gives you an overview of the current activity in total or broken down
into services and—in case of RAC—instances.
•
I/O:
The final pane on this page shows you I/O Requests, Throughput, and Latency.
Hover the mouse over these panes and you will notice they are all interactive.
Top Activity
This screen is like a combination of ASH Analytics you already know from Oracle Enterprise Manager Cloud
Control and the Top Activity screen we know from pre-Enterprise Manager 12c. The Top Activity page is shown in
Figure
2-10
:
Search WWH ::
Custom Search