10G Metric Manager Eats Almost 100% CPU
jmjacobsAug 25 2004 — edited Aug 31 2004Running 10.1.0.2.0 on Windows 2000.
10G is eating up nearly 100% of the CPU, even when I have no sessions. The offender seems to be Module: Oracle Enterprise Manager.Metric Engine running an "unnamed action".
The offending piece of code appears to be:
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN
EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate :=
next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
Which seems to take 74.93 seconds/execution.
All I'm doing is running some extremely simple SQLPlus scripts, but this happens after I've booted my machine and done nothing.
Any help will be appreciated.