Identify runaway job
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Identify runaway job

  1. #1
    Join Date
    Dec 2000
    Posts
    75
    My 817 DB is very busy generating archived log every 1/2 hour for 1 week or so or so while there is not seem to be any users or people doing anything. However we have process scheduler that I am suspicious of. v$sqlarea don't show any heavy sql's neither. I bonced the db once but didn't seem to help. The problem is that there is no Unix process show up so I can kill as this runaway job(s) is probably initiated via background. Can I look at any tables or views to help identify what is going on?

    goodhealth

  2. #2
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    You might want to check there is nothing running via DBMS_JOB. As the dba user, try

    SELECT * FROM DBA_JOBS;

    Cheers,
    OCP 8i, 9i DBA
    Brisbane Australia

  3. #3
    Join Date
    Dec 2000
    Posts
    75
    I did checked dba_jobs but there was nothing.

    The other reason might be some sql's might be runaway and been running for days. Is there a quick way to check on a sql and its duration, how long it has been running currently or in the past?
    goodhealth

  4. #4
    Join Date
    Oct 2000
    Posts
    467
    if you have the session_id of the sql, then check the logon_time from v$session
    Vinit

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