DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Procedures dying after running to certain record

  1. #11
    Join Date
    Sep 2002
    Posts
    411
    Pando,

    Sorry to come back to this topic again but I think it stop running. When I query the V$SESSION_WAIT I saw that the SECOND_IN_WAIT got bigger and bigger and as I said before when I look into the DAVE_TEMP table it stop on row 500 and it's staying there forever.

    Same query, ran on 9i and it ran less than 1 min the 9i server is even smaller than the 8i

    Do you have any other recommendation???

    As always, thanks for all the help

  2. #12
    Join Date
    Sep 2002
    Posts
    411
    till today,

    this procedure still haven't finished running.

    can someone please help???

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