Thread: why we call oracle 10g?

why we call oracle 10g and what is difference between 9i and 10g version?

oracle 10g is upgrade version. so it is effective than other version.

oracle 10g is upgrade version.and its use data grid form so we call oracle 10g.

i don't know but some share grid formating data sharing in oracle.

Oracle 10g have more extensible functionality than oracle 9i. so all are prefer oracle 10g.

As said, Oracle 9i has been upgraded to 10g with the features like SQL Tuning and access advisor, balancing load between standby databases and so on. Also that Oracle 10g supports Linux. Oracle hosting seems to be complex but it runs the business applications more easier.

I really do not know why they call them like that.

Each release of Oracle has many differences, and Oracle 10g is a major re-write of the Oracle kernel from Oracle 9i. I keep a list of the differences. While there are several hundred new features and other differences between 9i and 10g, here are the major differences between Oracle9i and Oracle10g:

• Major changes to SQL optimizer internals
• Oracle Grid computing
• AWR and ASH tables incorporated into Oracle Performance Pack and Diagnostic Pack options
• Automated Session History (ASH) materializes the Oracle Wait Interface over time
• Data Pump replaces imp utility with impdp
• Automatic Database Diagnostic Monitor (ADDM)
• SQLTuning Advisor
• SQLAccess Advisor
• Rolling database upgrades (using Oracle10g RAC)

Originally Posted by betterlive

why we call oracle 10g and what is difference between 9i and 10g version?

Oracle is a relational database and it follow Dr. E.F. Codd rules. There are twelve rules but we don't have any RDBMS which follow all Codd rules. Oracle9i means it follow 9 rules of RDBMS and "i" is the version and Oracle 10 g means it follow 10 rules and 'g' is the version.

Oracle is database which is used for save data. Oracle10g is upgraded version of Oracle9j

oracle is object-relational database management database system

oracle 9i and 10g there are implementation changes.In terms of architecture 9i is Internet technology based and 10g is grid computing based and also having the automates saved option.