This discussion is archived
4 Replies Latest reply: Jul 3, 2013 11:55 PM by Nikolay Savvinov RSS

Join Query hanging

902923 Newbie
Currently Being Moderated

hi experts,

 

please help on this, we have migrated database from 10g to 11.2.0.3 , Everything went sccessful but one of the simple join query hanging occasionally in new upgraded database. is there any known issue or anything need to add after migration for sqls?,also before migration its was executed without any issues. that query is joining and fetching from two more tables . is there any generic reason please provide that would be helpful to analyze, Thanks in Advance.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points