GV$SCHEDULER_RUNNING_JOBS
select inst_id, -- INST_ID NUMBER kglobt18, -- SESSION_ID NUMBER kglobt19, -- SESSION_SERIAL_NUM NUMBER kglobt17, -- JOB_ID NUMBER kglobt20, -- PROCESS_ID NUMBER kglobt21 -- SESSION_STAT_CPU NUMBER from x$jskslv where kglobt32 != 0

home |  up  |  mailbox