Managing Databases using Enterprise Manager (MOSC)

MOSC Banner

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center