I am running an application on Oracle 11gR2 that takes forever to complete - I started the app on May 30th and it was interrupted by a reboot of the machine on June 11th. Using Oracle 11gR1, it completes in about 30 hours. Can anyone tell me what the major differences are? Where can I start looking? Any performance tuning tips would be helpful as well.
Thanks!