This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,299 Users
  • 2,269,776 Discussions
  • 7,916,824 Comments

Discussions

Categories

DB Performance Monitoring Metrices

Jhil
Jhil Member Posts: 3,182 Bronze Trophy
edited Apr 29, 2020 5:47PM in Enterprise Manager

Dear Experts,

We completed DB patching activity.

We need to gather DB Performance Metrices before and after Patching by using OEM.

There are multiple tabs under performance, where do i find DB performance measured/monitoring  metrices by using OEM 13c ?

Thanks in advance.

Arsalan DehghanisariyarghanJhil
· Share on TwitterShare on Facebook

Answers

  • L. Fernigrini
    L. Fernigrini Database Practice Lead Rosario, ArgentinaMember Posts: 4,196 Gold Crown
    edited Apr 28, 2020 3:17PM

    Probably the SQL and PL/SQL forum is not the best place for this question, try on   or

    · Share on TwitterShare on Facebook
  • Venkata Thiruveedhi-Oracle
    Venkata Thiruveedhi-Oracle Senior Principal Software Engineer Bangalore, IndiaPosts: 592 Employee
    edited Apr 29, 2020 7:28AM

    Hi,

    It all depends on what exact metrics you want to validate.

    + The basic navigation to validate your DB performance is the Performance Home page.

    Performance Menu  -->  Performance Home

    Here you can see some of the details of how your DB is performing.

    + If you want to validate more details, then you can navigate to Performance Hub OR Top Activity page based on the DB plugin version you are using..

    Performance Menu  -->  Performance Hub (If you are using the 13.3.2 DB Plugin)

    Under this you can find the ASH Analytics & SQL Monitoring

    Performance Menu -->  Top Activity (If you are using the 13.3.1 DB plugin)

    These pages will give you more details data how your DB is performing.

    + If you are looking for more metrics at DB level to validate any specific metric, then you can navigate to:

    Database Home Page  -->  oracle database drop down  -->  Monitoring  -->  All Metric

    Here you get the complete list of metrics available and you can drill down to a specific metric you want to see for current values.

    Best Regards,Venkat

    JhilJhil
    · Share on TwitterShare on Facebook
  • BPeaslandDBA
    BPeaslandDBA Member Posts: 4,615 Blue Diamond
    edited Apr 29, 2020 10:39AM

    Keep in mind that going to the Performance section of EM for your database requires you to license the optional Diagnostics Pack (well worth the cost in my opinion).

    For before and after...you can always compare AWR reports. That is available in the Performance menu as well. And it does require the Diag Pack as well.

    Cheers,

    Brian

    JhilArsalan Dehghanisariyarghan
    · Share on TwitterShare on Facebook
  • Arsalan Dehghanisariyarghan
    Arsalan Dehghanisariyarghan Oracle DBA Team Leader / Oracle App DBA / EDA Member Posts: 372 Bronze Trophy
    edited Apr 29, 2020 5:47PM

    Hi, I also agree with Mr. BPeaslandDBA's answer.

    · Share on TwitterShare on Facebook