DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2001

    Tool to see what causes the hangup?


    I have a user that runs a small batch job (inserts, deleted) against the database. Normally, the job runs in 20-30 seconds. Once in a while, it may take up to 20 minutes for approximately the same number of records.

    I know I can use Statspack to get metrics, but is there a way I can find out what exactly is causing the job to run slowly? When I look at the database activity, it doesn't appear to be more than usual.

    Our UNIX admin says that systemwise, there are enough resources available.

    Does anybody have a script or know of a tool that could help me out?


  2. #2
    Join Date
    Jun 2000
    Madrid, Spain
    script or tool you are looking for is statspack, sql trace

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