I'm in the process of migrating a huge .net 3.0 app that uses Oracle 9i to Oracle 11g. From the database point of view I'm only using the following objects:
Are there any specific issues that I should take into account?
We went from 9i to 10G without any change to application code. Not specific to .Net but one small thing is the default sort order has changed. So if you have queries with no explicit order by and you depended on the order check them. I know that DBAs had tuned init.ora parameters differently as well.
your execution plans and object statistics - were you using the Cost or Rule Based Optimizer in v9 of the database?
Also, lots of performance enhancing technologies for PL/SQL introduced in 10 and 11g, see Steven Feurestein's stuff online on how to take advantage for starters.
