Results 1 to 2 of 2

Thread: urgent

  1. #1
    Join Date
    Oct 2002

    Unanswered: urgent


    I have a small problem..when running a procedure in a server which is processing only 64k records taking more than 3 hours time.. and this procedure is running with a job.. since two days iam getting "snapshot too old error" and the job is failing.. how can we tune it to reduce the time and how to over come this roll back segment problem...

    could you please tell me the steps to tune the procedure it is already having indexes.. but a cursor is used to fetch the rows and to update them with a condition..


  2. #2
    Join Date
    Nov 2003
    Rotterdam, Netherlands
    Tuning depends a lot on your code and ofcourse your table.

    Check the indexes you have created

    Mainly TUNE YOUR Quries in the procedure.

    with your explanation its very difficult to suggest more than 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