1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How can I see jobs that are concurrent stats in 11gR2

Discussion in 'Server Administration and Options' started by nomiezvr4, Apr 6, 2011.

  1. nomiezvr4

    nomiezvr4 Active Member

    Messages:
    2
    Likes Received:
    1
    Trophy Points:
    65
    Hey guys,
    I was wondering how can i see what jobs are running concurrent stats in 11gr2.

    What i do right now is select job_name, state, comments from dba_scheduler_jobs;
    and am looking in the comments section for jobs specifically stating concurrent but it isnt there.

    Is there a way I can tell if concurrent is set to true (or is on)? and if so how can I tell what jobs it is on for?

    Thanks in advance
     
  2. nomiezvr4

    nomiezvr4 Active Member

    Messages:
    2
    Likes Received:
    1
    Trophy Points:
    65
    Hey Guys I think i got it
    I can use
    select job_name, state, comments from dba_scheduler_jobs where job_class like 'CONC%'; to see if the jobs are concurrent
     
    Sadik likes this.