-
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
-
till today,
this procedure still haven't finished running.
can someone please help???
