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.
This forum is for migration from other Databases (Sql server, Sybase and so on) to Oracle.
May I suggaest you create a new thread in the forum Database - Upgrade ?
It is for Oracle Database Updates. I am sure that you will get the appropriate answer in it.