Difference Between Oracle 9i and Oracle 10g

Oracle 9i vs Oracle 10g

In 1977 Software Development Laboratories (SDL) developed the Oracle Database software which is simply known as Oracle. It is an Object-Relational Database Management System (ORDMBS) which is identified by an alpha numeric system identifier (SID).

The Oracle Database software includes a set of operating system processes such as PMON or process monitor and SMON or system monitor together and memory with data storage. In 2001, Oracle 9i was released, the “i” standing for the word “Internet” meaning that it is Internet ready. It has the following new features:

Direct XML database support.
Java JDK 1.3.
Oracle Data Guard and enhancements.
New data sharing and replication features.
Compresses keys in tables when loading data.
Security Improvements.
Manage system table spaces locally.
Automated DBA.

Oracle 10g, on the other hand, was released in 2003 to support regular expressions with the letter “g” standing for “grid” to emphasize Oracle 10g as grid computing ready. Here are some of its features:

New drop database and alter database begin backup syntax.
Oracle 10g Data Guard Broker and RAC to support Redo Log Transport.
SQL apply feature and regular expression support.
Supports HTML database.
Recycle bin for storing objects and new purge command.
SYSAUX table space and rename table space command.
Automated Storage Management (ASM).
Automatic Workload Repository (AWR).
Automatic Database Diagnostic Monitor (ADDM).

These two versions have many differences including the following:

Manageability. Oracle 10g is proven to be more manageable than oracle 9i.
New ADDM and SQL Tuning Advisor of Oracle 10g is a very remarkable improvement against that of Oracle 9i.
Oracle 10g lessens DBA workload and hastens performance of management tasks.
Oracle 10g executable is bigger.
Oracle 9i does not allow rollback after a drop while it is allowed in Oracle 10g.
Oracle 10g has more features and offers more efficient replication support than
Oracle 9i.
Oracle 10g has higher system requirements than Oracle 9i.

Both versions have excellent features. The main difference between the two is that Oracle 10g is a higher version than Oracle 9i and has many added features that enhance the features of Oracle 9i while some old features may have been abandoned.

Summary:

1.Oracle 9i is an Object-Relational Database Management System (ORDMBS) which was released in 2001 while Oracle 10g is also an Object-Relational Database Management System (ORDMBS) which was released in 2003.
2.The “i” in the Oracle 9i stands for “Internet ready” while the “g” in the Oracle 10g stands for “grid computing ready.”
3.Oracle 10g is actually an upgraded or a higher version of Oracle 9i.
4.Oracle 10g is more manageable while Oracle 9i is not.
5.Oracle 10g offers more features while Oracle 9i offers less.
6.Oracle 10g has higher system requirements while Oracle 9i has lower system requirements.
7.Oracle 10g also offers flashback, backup, recovery, and several other enhancements while Oracle 9i does not.

Sharing is caring!