Mailing List
Home
Forum Home
Oracle List - by freelists.org
Oracle on SUSE Linux - Runing Oracle on SUSE Linux
Oracle database error code ...
www.freelists.org
Subjects
• ORA 12540: TNS:internal limit restriction exceeded
• ORA 12838 please : Is possible to append two times to the same table befo
• ORA 12838 please : Is possible to append two times to the same table before
• ora 04031
• ora 12500 on windows
• ORA 32004: obsolete and/or deprecated parameter(s) specified
• ORA 01925: maximum of 30 enabled roles exceeded
• ORA 01925: maximum of 30 enabled roles exceeded
• ora 12500 on windows
• ORA 01650, one idea
• ORA 01650
• ORA 4030
• ORA 12838 please : Is possible to append two times to thesametable before do
• ORA 12838 please : Is possible to append two times to thesame table before d
• ORA 01536
• ORA 03113 end of file on communication channel
• ORA 32004: obsolete and/or deprecated parameter(s) specified
• ORA 00600:
• ORA 00020: maximum number of processes (%s) exceeded
• ORA 01925: maximum of 30 enabled roles exceeded
• ORA 3113 while creating a cluster database 9201 RAC on Linux with OCFS
• ora 12500 on windows
• ora 12500 on windows
• ora 12500 on windows
• ORA 01650, one idea
• ora 12500 on windows
• ora 12500 on windows
• ora 12500 on windows
• ORA 2000 Error Using DBMS STATS GATHER SCHEMA STATS
• ORA 01650, one idea
• ORA 01650, one idea
• ORA 01650, one idea
• ORA 01650
• ORA 01650
• ORA 01031
• ORA 4030
• ORA 4030
• ORA 06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
• ORA 01722 invalid number
 
-none-

-none-

2007-08-13       - By LS Cheng

 Back
Hi

I was wondeing if anyone knows how dbcontrol (or grid control) accounts CPU
usage in Average Active Session graph shown in Performance tab?

I cacthed a query and it does this

SELECT   begin_time, wait_class#, (time_waited) / (intsize_csec / 100)
   FROM v$waitclassmetric
UNION ALL
SELECT   begin_time, -1, VALUE
   FROM v$sysmetric
  WHERE metric_name = 'CPU Usage Per Sec' AND GROUP_ID = 2
ORDER BY begin_time, wait_class#

If we look historical data the query is this

SELECT   dat.sample_time, dat.NAME, dat.session_id, dat.session_serial#,
        dat.client_id, dat.sql_id, dat.service_hash, dat.module, dat.action
,
        dat.p1, dat.p2, dat.p3, dat.current_obj#, dat.current_file#,
        dat.user_id, dat.program, dat.samples, dat.time_waited / 1000000,
        dat.sql_opcode
   FROM (SELECT   'CPU Used' NAME, sample_time, session_id,
session_serial#,
                  client_id, sql_id, service_hash, module, action, p1, p2,
                  p3, current_obj#, current_file#, MAX (user_id) user_id,
                  MAX (program) program, COUNT (*) samples,
                  SUM (time_waited) time_waited, sql_opcode
             FROM dba_hist_active_sess_history
            WHERE dbid = 3289503984
              AND instance_number = 1
              AND snap_id BETWEEN 87 AND 88
              AND wait_time <> 0
              AND 'CPU Used' = 'CPU Used'
         GROUP BY sample_time,
                  session_id,
                  session_serial#,
                  client_id,
                  sql_id,
                  service_hash,
                  module,
                  action,
                  p1,
                  p2,
                  p3,
                  current_obj#,
                  current_file#,
                  sql_opcode) dat
ORDER BY dat.sample_time

Does these queries makes sense?

Thanks

--
LSC

Hi<br><br>I was wondeing if anyone knows how dbcontrol (or grid control)
accounts CPU usage in Average Active Session graph shown in Performance tab?<br
><br>I cacthed a query and it does this<br><br>SELECT&nbsp;&nbsp; begin_time,
wait_class#, (time_waited) / (intsize_csec / 100)
<br>&nbsp;&nbsp;&nbsp; FROM v$waitclassmetric<br>UNION ALL<br>SELECT&nbsp;&nbsp
; begin_time, -1, VALUE<br>&nbsp;&nbsp;&nbsp; FROM v$sysmetric<br>&nbsp;&nbsp;
WHERE metric_name = &#39;CPU Usage Per Sec&#39; AND GROUP_ID = 2<br>ORDER BY
begin_time, wait_class#<br><br>If we look historical data the query is this
<br><br>SELECT&nbsp;&nbsp; dat.sample_time, dat.NAME, dat.session_id, dat
.session_serial#,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dat.client
_id, dat.sql_id, dat.service_hash, dat.module, dat.action,<br>&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dat.p1, dat.p2, dat.p3, dat.current_obj#, dat
.current_file#
,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dat.user_id, dat.program,
dat.samples, dat.time_waited / 1000000,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp; dat.sql_opcode<br>&nbsp;&nbsp;&nbsp; FROM (SELECT&nbsp;&nbsp; &#39
;CPU Used&#39; NAME, sample_time, session_id, session_serial#,<br>&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; client_id, sql_id, service_hash, module, action, p1, p2,
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; p3, current_obj#, current_file#, MAX (user
_id) user_id,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MAX (program) program, COUNT (*
) samples,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SUM (time_waited) time_waited, sql
_opcode<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp; FROM dba_hist_active_sess_history
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
WHERE dbid = 3289503984<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND instance_number = 1<br>&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND
snap_id BETWEEN 87 AND 88<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND wait_time &lt;&gt; 0<br>&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND &
#39;CPU Used&#39; = &#39;CPU Used&#39;
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GROUP BY sample_time
,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; session_id,<br>&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp; session_serial#,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; client_id,<br>&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp; sql_id,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; service_hash,
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; module,
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; action,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
p1,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; p2,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; p3,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; current_obj#,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
current_file#,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sql_opcode) dat<br>
ORDER BY dat.sample_time<br><br>Does these queries makes sense?<br><br>Thanks
<br><br>--<br>LSC<br><br>