afcnoc
asked on
Oracle 10g vs 11g
My company is looking at starting a NEW project. I am looking for expert opinions on which Oracle version to go with, 10g or 11g.
The DBs running on this server will be pretty big, 1-2TB and I believe we will be using Oracle BI as well.
If you would like to add your opinion to this, please explain why you have a particular opinon.
The DBs running on this server will be pretty big, 1-2TB and I believe we will be using Oracle BI as well.
If you would like to add your opinion to this, please explain why you have a particular opinon.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
schwerter is right! 11g IS the best version in history. I feel it is the best database you can buy from any vendor.
My favorite 11g feature is virtual columns and the ability to create a partitioned table using a virtual column as the partitioning key.
As a DBA that has studied and took certification tests from several versions of Oracle, I will say that there is no reason to worry about your 10g knowledge getting lost. 11g does not really remove any features, but just adds new ones.
For anyone making this decision I recommend 2 things.
1) Spend an hour reading about the New Features : http://www.oracle.com/technology/pub/articles/oracle-database-11g-top-features/index.html
2) Review in Metalink the issues that concern you. If you intend to use an odd feature, check Metalink to see if any bugs relate to that feature. Case in point that I learned of this week, an 11g RMAN bug concerning compressed backupsets, when cloning a database. Some of these things can be worked around by using redundant methods, but do your homework (as you already are by asking questions here).
Good luck.
My favorite 11g feature is virtual columns and the ability to create a partitioned table using a virtual column as the partitioning key.
As a DBA that has studied and took certification tests from several versions of Oracle, I will say that there is no reason to worry about your 10g knowledge getting lost. 11g does not really remove any features, but just adds new ones.
For anyone making this decision I recommend 2 things.
1) Spend an hour reading about the New Features : http://www.oracle.com/technology/pub/articles/oracle-database-11g-top-features/index.html
2) Review in Metalink the issues that concern you. If you intend to use an odd feature, check Metalink to see if any bugs relate to that feature. Case in point that I learned of this week, an 11g RMAN bug concerning compressed backupsets, when cloning a database. Some of these things can be worked around by using redundant methods, but do your homework (as you already are by asking questions here).
Good luck.
ASKER
Thanks for the input. I am giving point to all 3 who answered based on the amount of input they gave.
Again, thanks for you time on this! It helped move me towards recommending 11g.
Again, thanks for you time on this! It helped move me towards recommending 11g.
very big investment. To ensure longer ROI (Return Of Investment)
it is better to begin with 11g