4 Replies Latest reply: Jul 13, 2012 6:26 AM by Pinela RSS

    Repository views for performance chart

    Pinela
      Greetings all,

      I found this page
      [http://docs.oracle.com/cd/B19306_01/em.102/b16246/views.htm |http://docs.oracle.com/cd/B19306_01/em.102/b16246/views.htm ]
      about Oracle® Enterprise Manager Extensibility
      but I can't seem to find what I want.

      Can anybody tell me were I can find the information that feeds the charts on the Performance Tab? Like the "average active sessions"?
      I would like to build a multi-target chart.

      Thank you.
      BR,
      João Pinela.

      Edited by: Pinela on Jul 2, 2012 11:19 AM
        • 1. Re: Repository views for performance chart
          Adeesh Fulay
          Pinela,

          Unfortunately, there is no guarantee that all data visible via EM pages will be available from the published repository views. In the current case, your best bet would be to query the monitoring views filtered by the database target type.


          Doc Url:
          http://docs.oracle.com/cd/B19306_01/em.102/b16246/views.htm#BACDGFJC
          • 2. Re: Repository views for performance chart
            Pinela
            Thanks for the help.

            >
            Unfortunately, there is no guarantee that all data visible via EM pages will be available from the published repository views
            >
            well they have to be somewhere, because when you open the chart you can see the values for the last hour. So the data can be obtained. And I don't think that the agent will supply be historic data. Do you agree?

            you suggest this view?
            >
            MGMT$METRIC_ERROR_HISTORY
            >
            like
            select * from MGMT$METRIC_ERROR_HISTORY where target_name='POR.WORLD'
            ?

            thanks.
            Br,
            Pinela.
            • 3. Re: Repository views for performance chart
              Adeesh Fulay
              No i was linking to the monitoring views section. Specifically, you would want to look at the following views:

              MGMT$METRIC_CURRENT
              MGMT$METRIC_HOURLY
              MGMT$METRIC_DAILY
              • 4. Re: Repository views for performance chart
                Pinela
                hello afulay,

                thanks. I think that is it. there are some discrepancies between the following query:
                select target_name, sum(value) tot_sessions from mgmt$metric_current 
                where (column_label like '%Active Session%'
                --or column_label like '%Network%'
                ) and target_name in ('POR.WORLD')
                and target_type='oracle_database' group by target_name;
                and the GC chart, but I think this is it. just have to parse the data.

                Thanks.
                BR,
                Pinela.