DBA_JOBS_RUNNING definition still not corrected for RAC 11g
Just found this one and since I do not trust until I see it..
Here is Bug description.Only affects RAC…
There will be no output when queried for information on same job from other RAC instances. This is because the view definition makes use of v$lock information in joins and not the gv$lock.
According to Oracle this is Bug and should be fixed in 11g but it is NOT.
SQL> set long 1000
SQL> select * from v$version;
BANNER
——————————————————————————–
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – 64bit Production
PL/SQL Release 11.1.0.6.0 – Production
CORE 11.1.0.6.0 Production
TNS for Linux: Version 11.1.0.6.0 – Production
NLSRTL Version 11.1.0.6.0 – Production
SQL> select text from dba_views where view_name=’DBA_JOBS_RUNNING’;
TEXT
——————————————————————————–
select v.SID, v.id2 JOB, j.FAILURES,
LAST_DATE, substr(to_char(last_date,’HH24:MI:SS’),1,8) LAST_SEC,
THIS_DATE, substr(to_char(this_date,’HH24:MI:SS’),1,8) THIS_SEC,
j.field1 INSTANCE
from sys.job$ j, v$lock v
where v.type = ‘JQ’ and j.job (+)= v.id2
The v$lock is still there.So if you running RAC redefine it yourself and DO NOT WAIT FOR ORACLE ( See previous post ).
Details Metalink Note: 357564.1
