I needed to make use of the log_id of USER_SCHEDULER_RUNNING_JOBS. I was surprised to find that it is not the number of integers. Not looking for a long time - probably in the source text of USER_SCHEDULER_RUNNING_JOBS or ALL_SCHEDULER_RUNNING_JOBS
bitand(j.running_slave, 18446744069414584320) / 4294967295
there is an error that should have been corrected as follows:
bitand(j.running_slave, 18446744069414584320) / 4294967296
Am I right?
While I was forced to use a workaround:
(Log_id * 4294967295) / (4294967295 + 1)
Edited by: sns on 20.03.2013 10:12