question

Hector Minaya avatar image
Hector Minaya asked

Migrating .net 3.0 app from 9i to 11g

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:

  • Packages
  • Procedures/Functions
  • Types
  • Oracle Directories

Are there any specific issues that I should take into account?

migration9i11g
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

pratikk avatar image
pratikk answered

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.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

HillbillyToad avatar image
HillbillyToad answered

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.

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks. I'll look into it.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.