2 Replies Latest reply: Mar 21, 2013 12:44 PM by sns RSS

    Column log_id in USER_SCHEDULER_RUNNING_JOBS or ALL_SCHEDULER_RUNNING_JOBS

    sns
      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