Dear gurus, Mohon bantuan nya kali aja yg punya pengalaman. Di database terdapat job error yang bernama ORA_MONITOR jobs, pada OS process ORA_MONITOR job ini memakan processor sebesar 99%. saya coba stop job tersebut tapi tidak bisa. muncul error ketika stop job ini seperti contoh,
SQL> execute dbms_job.broken(61,TRUE); BEGIN dbms_job.broken(61,TRUE); END; * ERROR at line 1: ORA-23421: job number 61 is not a job in the job queue ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86 ORA-06512: at "SYS.DBMS_IJOB", line 529 ORA-06512: at "SYS.DBMS_JOB", line 245 ORA-06512: at line 1 I upload content of dba_jobs. jobs that error is ORA_MONITOR with job id = 61. these are error on my alert log, ORA-12012: error on auto execute of job 61 ORA-01722: invalid number ORA-06512: at "ORA_MONITOR.DB_PERF_MONITOR", line 211 ORA-06512: at line 1 -- Best Regards, Andes [Non-text portions of this message have been removed]
