What is the difference between 9i and 10g.(especially i and g stands)

Questions by Rampraas   answers by Rampraas

Showing Answers 1 - 16 of 16 Answers

pradeep

  • Aug 2nd, 2011
 

Oracle 9i and Oracle 10g....there are more implementation differences. In terms of architecture, 9i is based on Internet technology while 10g is grid computing based one. Many DBA features like Automated Storage Management (ASM), Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) were introduced.

For developers, 10g is more stable than 9i. All the earlier bugs reported were fixed in 10g release.

Performance wise, it was more impressive. It increased the data chunk size during I/O between the SQL and PL/SQL engines. Use of collections was recommended.
PLS_INTEGER, a new data type was added which enhances performance. ANYDATA data type was introduced to hold a data of variant feature.

FLASHBACK option was made more stronger like TABLE FLASHBACK was introduced. Regular expression function were introduced REGEXP_SUBSTR, REGEXP_INSTR, REGEXP_REPLACE.

Oracle Recyclebin was introduced. The dropped objects can be restored from the recyclebin until it is purge

  Was this answer useful?  Yes

tej

  • Apr 23rd, 2012
 

The Oracle version starting of I. The starting in 1999 with version 6i, 8i and 9i, I signify "Internet" means stands for "Internet" and Oracle added the "I" to the version name to reflect support for the Internet with its built-in Java Virtual Machine (JVM). Oracle 9i added more support for XML in 2001.
Meaning of G in Oracle:
The starting in 2003 with version 10g and 11g, G signifies "Grid Computing" with the release of Oracle10g in 2003. Oracle 10g was introduced with emphasis on the "g" for grid computing, which enables clusters of low-cost, industry standard servers to be treated as a single unit. Upgrade Enterprise Manager 10g Grid Control Release 4 (10.2.0.4.0) or higher to Enterprise Manager 11g Grid Control Release 1 (11.1.0.1.0).

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions