This discussion is archived
2 Replies Latest reply: Mar 21, 2013 10:44 AM by 982219 RSS

Column log_id in USER_SCHEDULER_RUNNING_JOBS or ALL_SCHEDULER_RUNNING_JOBS

982219 Newbie
Currently Being Moderated
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)

Thank you!

Edited by: sns on 20.03.2013 10:12

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points