Oracle 9i and Oracle 10g are two different generations of the Oracle database software. They have many features in common, but also some significant differences. This article discusses some of the key differences between these two versions of Oracle. It is important to understand these differences before you decide which version to use for your business.
What is Oracle 9i?
Oracle 9i is a relational database management system (RDBMS) produced by Oracle Corporation. It is the successor to Oracle 8i and was released in 2001. Oracle 9i introduced support for Internet standards such as XML, Java, and Enterprise JavaBeans (EJB). It also added support for Real Application Clusters (RAC), a feature that allows multiple instances of Oracle to run on a cluster of servers. Oracle 9i was the last release of the Oracle database to support the Motif graphical user interface (GUI). Oracle 10g, released in 2004, dropped support for Motif and replaced it with a new GUI called Oracle Enterprise Manager.
What is Oracle 10g?
Oracle 10g is a relational database management system released by Oracle Corporation in 2004. 10g is the 10th generation of Oracle’s database technology. 10g introduced a number of new features, including Automatic Storage Management, Real Application Clusters, and Oracle 10g Express Edition. Automatic Storage Management is a system for managing storage that is integrated with the database. Real Application Clusters allow multiple instances of the database to be run on a cluster of servers. 10g Express Edition is a free, lightweight edition of the 10g database. Oracle 10g was followed by 11g, which was released in 2007.
Difference between Oracle 9i and Oracle 10g
Oracle 9i was released in 2001 and Oracle 10g was released in 2003. Oracle 10g is an upgrade to Oracle 9i with some new features added. Oracle 9i is a 32-bit database while Oracle 10g is a 64-bit database. Oracle 9i can run on any platform that supports 32-bit OS while Oracle 10g can run on any platform that supports 64-bit OS. Oracle 10g has a new feature called Real Application Clusters (RAC) which allows multiple instances of Oracle Database to run simultaneously on a cluster of servers.
Oracle9i has the Automated Storage Management (ASM) feature which helps in managing the storage and administration of Oracle databases.Oracle10g also has an improved ASM feature which makes it easier to use. Oracle9i uses the Program Global Area (PGA) memory for storing data whereas Oracle10g uses the System Global Area (SGA) memory for storing data.Oracle10g has a new feature called SQL*Plus Connectivity which provides enhanced connectivity to the database. It also has a new data COMPRESSION feature which helps in reducing the size of the database.
Conclusion
Oracle Corporation released two new versions of its namesake database product in 2003: Oracle 9i and Oracle 10g. While both products share a great many similarities, there are also some noteworthy differences between the two releases.
