Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002

    Unanswered: Stored procedure hanging

    Have two stored procedure that have been running fine up until two days ago. One used to take several seconds to run but now takes more than 20 minute and is causing the batch job that runs it to time out. The other runs without doing anything. No changes to the code or application have been made. Any recommendations?

  2. #2
    Join Date
    Sep 2002
    Provided Answers: 1

    Re: Stored procedure hanging

    Use trace/TKPROF to look for poorly performing SQL. There is also a DBMS_PROFILER package that can check what your PL/SQL is doing. I haven't used that though.

Posting Permissions

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