Monitoring a job running in the database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Monitoring a job running in the database

  1. #1
    Join Date
    Dec 1999
    Posts
    217

    Monitoring a job running in the database

    Hi Guys,

    If a user comes to you and tells you that there is a job running in the database and he wants to know what is going on with it, 'cause the job normally takes a couple of minutes and today it is running for hours, what would the chain to actions in the database be?
    Right now I have a user hovering over me he has a job that has been submitted from the mainframe to the Oracle database, wherein the job picks up data from a flat file and inserts it in a table in the Oracle database. I checked the database and I do see the job as an active job running and it is inserting data in the table mentioned. WHat would you suggest to do next to troubleshoot the job?
    I checked the job from the Oracle Enterprise Manager Console.
    Your input would be highly appreciated.

    Thanks in advance.
    Chintzs

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    Is the table locked? This could explain it.
    Also, if it normally runs in minutes why not just kill it and re-run it?

    MH
    I remember when this place was cool.

  3. #3
    Join Date
    Feb 2004
    Posts
    50
    Check the session in v$session_wait to see if it is waiting on anything.
    Do several selects, about 5 seconds apart.
    You'll need to format the output to make it more readable.

  4. #4
    Join Date
    Mar 2002
    Location
    Manchester, England
    Posts
    202
    have a look at this
    HTH

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width