DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 1999

    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.

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

    I remember when this place was cool.

  3. #3
    Join Date
    Feb 2004
    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
    Manchester, England
    have a look at this

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.