DBA’s and
other users of the Oracle Enterprise Manager Cloud Control are very
familiar with the ‘Top Activity’ page under Performance of a database target.
Mostly,
this is the first page to watch when questions arise on database performance.
This page
uses Adobe Flash for the graphs. Hopefully, you are aware that Flash is
end-of-life by the end of 2020. So how does this affect Oracle Enterprise
Manager?
Until OEM
13.3, we see the Top Activity. If you use the Database Plugin 13.3.2, this is
being supported by JET and
not by Flash (see https://support.oracle.com/epmos/faces/DocumentDisplay?id=2309503.1).
Not only
this page uses Flash, many more pages are listed in the support note.
You can
check your plugin version, via Setup > Extensibility > Plug-ins
In the
above example, the 13.3.2 plugin should be deployed on the OMS, this would
disable the Flash usage. Updating the plugin is an option, if you are not able
to upgrade the OMS to 13.4.
Now what
about the latest Enterprise Manager version 13.4?
Below a
screenshot of a fresh 13.4 installation. As you see, the Top Activity is gone
(!!!) This may be a horror scenario to many DBA’s, who have used this option
for over a decade.
The
document describing this not-so-sudden disappearance, is https://support.oracle.com/epmos/faces/DocumentDisplay?id=2528627.1 .
This
document explains to start using Performance Hub > ASH Analytics. The
latest version of Active Session History Analytics provides a whole new view
on the top
Processes/Users in the database. This page will also show you again a Top-n
view, as shown in the larger example below.
What I’ve
seen thus far on the ASH Analytics, is a very detailed and well-designed
replacement of the Top Activity page. So don’t be scared, things will change –
as always.
Disclaimer:
all views and ideas are my personal interpretation on the way Oracle
software works. Note that you are always self responsible for your
environment, its configuration and licensing.
