What is the difference between Oracle 9i and Oracle 10g?

If you would try to look at Oracle 9i and Oracle 10g, you know for a fact that Oracle 10g is bound to be better because it is the upgrade. A lot of people are even saying that the improvement is truly remarkable.

There are a lot of added features that are similar to that of the Oracle 9i but enhanced in such a way that you will have a lot of fun using the new and added features. There are also some features that may not be that needed that have already been abandoned so you do not need to take up a lot of space anymore for the features that you do not need.

You can get to know the various features so that you can consider migrating to Oracle 10g if you are still using Oracle 9i.

An oracle is an Object-Relational Database Management System, which includes operating systems and memory with data storage. Oracle 9i was released in 2001, while oracle 10g was released in 2003.

The “I” in oracle 9i stands for “internet,” while the “G” in oracle 10g stands for “Grid.” Oracle 10g is an improved and better version of oracle 9i. Oracle 9i supports direct XML database while oracle 10g supports HTML database. Oracle 10g is more manageable than the oracle 9i.

Oracle 10g requires a higher system more than the oracle 9i. The oracle 10g has more features and has a better ADDM and SQL tuning advisor than the oracle 9i. Oracle 10g allows rollback after a drop while the oracle 9i.