5 Replies Latest reply: Apr 22, 2013 7:26 AM by EdStevens RSS

    Oracle Graphical monitoring CPU

    R. Royal
      Oracle Version: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit
      O.S. : 64-bit Windows

      Hi,
      I'm monitoring the Oracle database by checking the performance from 17 APR to 19 APR.
      I used AWR and ADDM (txt format).
      Now I need to make the graphics CPU from 17 APR to 19 APR, but do not know any way to create these charts.
      Is there a graphical free tool or other self-diagnostic software or ADDM in html format to generate these graphs?

      What steps should I perform?

      Thanks in advance!
        • 1. Re: Oracle Graphical monitoring CPU
          Aman....
          I don't think that there is any such tool by default available but you can use APEX(Application Express) for creating such charts by feeding the data into the tables of it by yourself.

          Aman....
          • 2. Re: Oracle Graphical monitoring CPU
            DK2010
            Hi,

            Or you can do it by using the tables dba_hist_active_sess_history,dba_hist_snapshot and copy o/p in excel and make chart there
            • 3. Re: Oracle Graphical monitoring CPU
              Kunwar
              Hi,
              What i do is run the below sql and then chart it using pivot in excel. You need to give the begin snap id and end snap id which you can get from dba_hist_snapshot .
              set verify off
              set feedback off
              set timing off time off
              set termout off
              set markup html on
              DEFINE DT=""
              column dt new_value dt
              select to_char(sysdate,'DDMONYY_HH24MISS') DT from dual;
              set timing on
              spool cpu_&DT..xls
              select to_char(begin_time, 'yyyy/mm/dd') s_day,
                   to_char(begin_time, 'hh24:mi') s_min,
                     round(average,2) avgval,
                     round(maxval,2) maxval
                From DBA_HIST_SYSMETRIC_SUMMARY
               where metric_name='Host CPU Utilization (%)'
                 and snap_id between &1 and &2 order by 1,2;
              set markup html off
              spool off
              EOL
              set termout on
              set feed on
              • 4. Re: Oracle Graphical monitoring CPU
                R. Royal
                Do you have any example of a chart CPU in excel format?
                • 5. Re: Oracle Graphical monitoring CPU
                  EdStevens
                  R. Royal wrote:
                  Do you have any example of a chart CPU in excel format?
                  that would be technically very difficult if not impossible to do on this forum. Besides, that is actually a question about how to use Excel. Charting in Excel is very easy. And believe it or not, Excel has a built-in help feature that can lead you straight to it.