Enterprise manager Cloud Control, monitoring issue?
Oracle database monitoring, in performance hub the graph is showing use of 1 cpu. The Oracle.Exe (S001) maintenance job active. Server showing only 3% cpu, should be 25% if 1 of 4 cpu is used. image 1
Logging in to Enterprise Manager Database Express, the cpu in cloud control drops, and now the monitoring shows correct. Anyone else have this issue? Bug? Image 2
Cloud Control after logging into DB Express, image 3.
The sql :
select * from (select session_id, session_serial#, program, module, action,sum(decode(session_state,'WAITING',0,1)) "CPU", sum(decode(session_state,'WAITING',1,0)) - sum(decode(session_state,'WAITING',decode(wait_class,'User I/O',1,0),0)) "WAITING" , sum(decode(session_state,'WAITING',decode(wait_class,'User I/O',1,0),0)) "IO" , sum(decode(session_state,'WAITING',1,1)) "TOTAL"from v$active_session_history where session_type='FOREGROUND'group by session_id,session_serial#,module,action,programorder by sum(decode(session_state,'WAITING',1,1)) desc);where rownum <11;