JOB_ID in V$SCHEDULER_RUNNING_JOBS = OBJECT_ID in DBA_OBJECTS
From: Mladen Gogala <mladen_at_bogus.email.com>
Date: Sun, 7 Jun 2009 09:29:10 +0000 (UTC)
Message-ID: <h0g196$ip9$2_at_solani.org>
I was just awaken by the system administrator who was, in turn, awaken by a nagios beep about the CPU that was running amok on one of my database servers. The "top" command (platform is 10.2.0.4 on RH EL 4.2/ x86-64) identified the process as J003 and V$SCHEDULER_RUNNING_JOBS gave me the JOB_ID.
Now, there is no documentation as to what is "JOB_ID", there is no such column in the DBA_SCHEDULER_JOBS. After short digging, I discovered that there is table called SYS.SCHEDULER$_JOB and that the JOB_ID column in V$SCHEDULER_RUNNING_JOBS corresponds to OBJ# column in the SYS.SCHEDULER$_JOB. If you check how the DBA_SCHEDULER_JOBS view is constructed, you will see a join with SYS.OBJ$ on the OBJ# column. In other words, one can query DBA_OBJECTS to find out the corresponding job information. JOB_ID = OBJECT_ID. Interesting thing to discover, especially when awaken at night.
Date: Sun, 7 Jun 2009 09:29:10 +0000 (UTC)
Message-ID: <h0g196$ip9$2_at_solani.org>
I was just awaken by the system administrator who was, in turn, awaken by a nagios beep about the CPU that was running amok on one of my database servers. The "top" command (platform is 10.2.0.4 on RH EL 4.2/ x86-64) identified the process as J003 and V$SCHEDULER_RUNNING_JOBS gave me the JOB_ID.
Now, there is no documentation as to what is "JOB_ID", there is no such column in the DBA_SCHEDULER_JOBS. After short digging, I discovered that there is table called SYS.SCHEDULER$_JOB and that the JOB_ID column in V$SCHEDULER_RUNNING_JOBS corresponds to OBJ# column in the SYS.SCHEDULER$_JOB. If you check how the DBA_SCHEDULER_JOBS view is constructed, you will see a join with SYS.OBJ$ on the OBJ# column. In other words, one can query DBA_OBJECTS to find out the corresponding job information. JOB_ID = OBJECT_ID. Interesting thing to discover, especially when awaken at night.
-- http://mgogala.freehostia.comReceived on Sun Jun 07 2009 - 04:29:10 CDT