4 Replies Latest reply: Mar 14, 2011 4:00 AM by 846308 RSS

    Going to Oracle 10 or 11 and a server question

      I'm a Java programmer and a Transact SQL DBA. So i have knowledge about databases. Nowwe have a database who performs very bad and got much deadlock problems and so on. It's an Oracle Database.

      We have Oracle version 9 and an application in Delphi. The bad performance is only since a while. We have cleaned the archive.
      My suggestion is why not migrate to a newer version of Oracle. Change some hardware specs get up to date.Then i think we will have less problems.

      But ofcourse this is more trail on error. That why i hope there is an Oracle specialist here who can help me with a few questions.

      Users and Specs
      I got 150 till 180 users
      i got a server with 1 processor XEON 233 GHZ
      4 gig memory

      1. Is it a good idea to upgrade? Maybe not to solve al the problems, but version 9 is old, there is version 10 or 11.

      2. Which version we should use 10 or 11? 11 is in use for a while so this sounds like a good idea.

      3. Are the specs OK or must i do something about the server to?
      Maybe dual core, or Enterprise (64 bit). Memory upgrade?

      4. Maybe for 64 bit i need Oracle version 11 to have good support on it?

      I hope somebody can help me a bit.


      Kind regards,