please help on this, we have migrated database from 10g to 22.214.171.124 , 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.
why wasn't this discovered during testing prior to the upgrade?
does new DB have current statistics?
How do I ask a question on the forums?