Aged Yak Warrior
Posted - 02/18/2014 : 20:11:09
I am running one stored procedure in which it contains union and inserting into another table which is referred in joining condition also. Its runnign morethan 5 hours but not completed yet but it useally tooks only 4 minutes earlier.
But its taking too long time to run and when i monitor this in activity monitor cxpacket wait type and wait resource of exchange event ID=pipe362 it shows.
Please suggest how can i fine tune this.
SQL Developer and DBA